Yeah, this matches my experience.

A supercapacitor buffer will cost around twice as much and deliver around 1/10th the watt-hours of a similarly-sized lead acid battery. And lead acid isn’t exactly great to begin with.

Capacitors are useful, but only in applications where the total amount of energy stored is more-or-less unimportant.