Although your point is valid to a certain extent, I think you're exagarating the 'problem' of charge and voltage being proportional. Modern switched mode power converters can do a good job.

Additionally I could see a solution in which not all capacitors are use at the same time. By activating them in a proper order/way, one could make a more constant source that can then be the input for a SMPS.