It's useful when you have a circuit which needs a high-current burst which is powered from a low current (but high capacity) power source.
One application for this is lasers. I'm part of a team that works on a converter that uses wall power as an input to continuously charge a few dozens ultracaps then empties them all at once to fire very short pulses in the hundreds of kW.
What I find the most impressive about this is that the mechanical engineers have managed to fit this in a 2U rack.
Holy crap, what can you do with kW lasers besides instantly cut almost anything?
kW isn't that high for pulsed lasers. Particularly since with Q-switching you can get very short pulses and mode-locking ridiculously short pulses. Total energy for a 1ps pulse at 100kW is negligible.
Exactly. Since the output is not continuous, the average power remains quite low. This is why you can still power it from regular domestic power :)
You get some nasty ionization effects with shorter pulses, right? I did some work trying to model a fs pulse laser in college.
Popcorn?
A much cooler (but obsoleted by improving capacitor technology) was flywheel based pulsed energy:
http://www.bevoware.com/research/cem/IEEE/PR%2071%20Werst%20...
Also, here's a page [2] with a list of common battery chemistries and ballpark figures for their energy density values (about halfway down in green). Newer Li Poly tech is somewhere in the 180Wh/kg range.
The sad thing about this is that we're missing a bigger point. Capacitors are useful because of their low internal impedance. They're able to dump (or receive) a tremendous amount of power incredibly quickly. It's useful when you have a circuit which needs a high-current burst which is powered from a low current (but high capacity) power source.
1: http://www.usc.edu/CSSF/Current/Projects/S0912.pdf
2: http://www.allaboutbatteries.com/Battery-Energy.html