If you are really needing 100's of uF, I would consider some adequately rated electrolytics.
Long gone are the times of the capacitor plague: there are some pretty neat capacitors specified for extended temperature ranges.
Unfortunately MLCC's seem to be an ideal solution to all problems, but for some applications (e.g.: high capacity bulk) they are far from that. If you work with 24V or even only 12V, you must take into account the voltage-capacity derating and end up with 63V to 100V rated MLCC's, in a Flexitherm(R) package: a quite bulky, very expensive and overall fragile solution.
MLCC's still find their ideal spot in the nF to the uF range for supply decoupling and POL bulk. I use Flexitherm(R) myself for our automotive* projects, but generally from 1206 footprint and upwards. I never actually needed to go for the flexible technology for 0603 and 0805 caps - never had a failure with those, to be honest.
*most of our projects are in the railway sector, so the lifetime requirements and vibration and temperature cycling specifications are quite harsh.