Almost every fish that stings (and I can't think of one available in the aquarium trade that isn't this way) does so for defense, not offense.
If you put your hand in the tank, they will generally avoid your hand at all costs. Corner them, however, and it may be a different story. Volitan Lionfish pack enough punch to put you in the emergency room for a good solid sting. Foxfaces and such will hurt like a bee sting, but nothing serious.
None of the fish you mentioned though will attack you unless they think you are food or you trigger a "flight for fight" response from them. Even if they do think that you are food, these animals don't sting their food to death, so they won't use their stingers on you for that reason, they'll just come closer than you like.
I've never had a problem with the Lions that I've kept. I have one in my FOWLR at the moment, when I clean the tank, I usually have a helper keep an eye on him, and I just stay on the side of the tank he's not on. When he wanders over near me, I just clean somewhere else. If he really gets in my way, I can shoo him away with my hand and he swims away. As long as you stay away from the dorsal spines, it's no biggie.
In the end, as long as you respect the animal and don't get them in a situation where they have to defend themselves, you should never have an issue. I've heard stories about lionfish just ramming people with their fins, but it's usually a case of them cornering them and not realizing it.