Now that you've heard the standard wisdom on "how much power", I'll step in with my radical 2 cents...
But first I'd like to point out that power vs. decibel SPL is not linear in the real world. Speakers experience a phenonmena called power compression--as the voice coil heats up, it's resistence rises and its ability to load the amplifier decreases, thus reducing power transfer to mechanical energy. Another factor is core saturation--the magnetic motor has a finite permeability. This has a curve too, and it's not linear. So a speaker rated 90dB 1W 1M may suffer 4-5 dB power compression at the rated 100W, so in effect, 105dB is the real maximum output level.
Power compression has been a long term challenge for industrial professional sound reinforcement applications, and designers have come up with methods of reducing the phenomena, ranging from humungous voice coils, to servo pistons, to horn-loaded systems, to Neodymium magnets and specially-designed core/pole piece systems. There has been a lot of development along these lines in the past 4-5 years.
Of course, the standard issues everyone knows about, the rise in distortion as power input increases, is also a factor with these consumer loudspeakers, so I would be remiss to imply that it doesn't.
Now, here's a new take on things.. what does a true audiophile try to achieve? Realistic reproduction of sound--any sound. So what happens when you watch a movie like
U-571 where depth charges are exploding from all directions? You've already set the level for natural dialog volume, but now along comes these explosions, some 25dB louder than the dialog. In reality, these sounds are concussive, well in excess of 120dB and consisting mostly of low frequencies in the 10-15Hz range. If one is seeking realistic conveyance of the experience, as the producer of this movie apparently was trying to achieve, then one needs to be able to get those low frequencies up above 120dB, for the full chest-caving experience of being on a U-boat under attack.
Now there's probably at least two philosophies here: if you're going to experience the film in its fullest, may as well share the danger.
The other school is that of spectators behind an iron fence, shielded from the full impact of the event.
So it's either, get in the cage with the lion and feel the terror and thrill, or stand on the other side of the fence and watch the lion from a safe distance.
So, how much power do YOU really need? It's up to you. Do you enjoy working with explosives? Do you like firing high caliber weapons? Do you enjoy going to battle reenactments with live cannons and still want for more? Do you enjoy watching shuttle launches? These are all events which go way past the safe threshold for hearing. But if you crave the real thing, it just eats away at you until you get it. So if you're watching that 1 in a 1000 movie that's got a really heavy soundtrack and you're feeling you wish you had more umppphhh, then you need more power. That's all the way around--more powerful speakers, more amplifier power (dependant on speaker efficiency) and possibly a dedicated ac line for the amplification equipment. Oh, and, no neighbors within a mile of your address.
Seriously, ask yourself, what kind of persona am I? Do my tastes fall into the average, or am I on the lunatic fringe? Maybe somewhere in between? What kind of program material do I listen to? String quartets? Or pipe organs? If it ranges from Bach to Bassotronics, then you need unusual speakers and copious amounts of amplifier power. Get ready to DIY, because you won't be in the world of consumer products anymore.
Train yourself to know what loudness levels are at different frequencies. 125dB at 2KHz is pretty darned painful. But at 20Hz, it's quite soothing. How much do you want to feel that explosion in the war movie? Just perceptably? Or chest caving in til it knocks the wind out of you? There's about a 30dB difference there. You figure the difference in power.
If you're on the extreme end, then you need to determine whether your home can stand the shaking without damage, and what sort of structural reinforcements will be needed to improve safety. There is nothing more stressful than having a 4x8 sheet of sheetrock fall from the ceiling during the opening to
Also Sprach Zarathustra. It can really ruin your day.
How real do you want YOUR reality?