That is a pretty general question. It all depends on what characteristics you need for a given capacitor.
The capacitance is only part of the requirements usually.
At the moment, the maximum reasonable and reasonably available capacitance you'll find with SMD ceramic capacitors is 47µF - obviously at relatively low operating voltages.
10µF can be easily found down to 0603 at low voltages. 22µF will usually be found in 0805 packages and larger.
For anything above 47µF, you can either resort to paralleling several ceramic caps, or go to electrolytic or tantalum.
Now there can be reasons for using electrolytic caps or tantalum caps beyond the available capacitance. For instance, sometimes their relatively higher ESR is actually desirable (while the typ. ESR for ceramic capacitors is very low.)
Typically, for a 100µF+/35V capacitor, if paralleling ceramic caps is not an option for your design constraints, a tantalum cap or electrolytic cap will do. Tantalum SMDs are usually smaller for a given capacitance and operating voltage. A typical 100µF/35V tantalum cap will come in "D" to "F" packages. Electrolytics are almost always much taller, so if height is a problem, they are not an option.
Another factor, beyond characteristics (ESR, parastic inductance) is the cost. Tantalum caps tend to be the most expensive.
Yet another factor is MTBF. Electrolytic caps (at least in general) will be the ones with the lowest MTBF compared to tantalum and ceramic, and will eventually end up leaking or drying up at some point. Can be a few years to a few decades depending on construction and operating conditions.
Finally, another factor is failure modes. Each of these 3 types of caps have different failure modes. Electrolytics tend to dry up or leak over time. Tantalum don't wear out as easily, but if they ever fail, they'll usually fail as shorts - which can blow up themselves and the circuits around them. Not pretty. And, ceramic capacitors can suffer from cracking (which can either lead to open or short circuits), most often caused by mechanical constraints (shocks, vibration.)
That's all for now.