This depends on what you are doing with the cap, if a DC/DC output with specified min ESR
I would agree. Otherwise choosing a charge source with higher esr makes absolutely no sense.
Unless of course your design seeks larger transients. And Pdiss.
It's all about the frequency.
"Ceramic caps right at the IC pins", ESL and antiresonance is all about high frequency stuff. Very, very low energy up there -- not enough time to cause any worthwhile dissipation!
Or to put it another way:
If you have a high power RF amplifier*, yes, you can have considerable energy at high frequencies. Logic circuits have only a small fraction, due to switching harmonics. We need to provide a low enough impedance to keep the voltage stable, but beyond that -- no worries.

*Which isn't that obscure; GSM and Wifi (AP) radios can be quite hungry. One would hope they've filtered the RF from their supply rails, within the module, though!

This would be my answer to why use polymer, basically a better cap https://en.wikipedia.org/wiki/Polymer_capacitor
http://www.nepp.nasa.gov/docuploads/0EA22600-8AEC-4F47-9FE49BAABEAB569C/Tantalum%20Polymer%20Capacitors%20FY05%20Final%20Report.pdf
I do seem to be overreacting, as I see modest ESR polymer aluminum and tantatum parts on Digikey. But by and large, the vast majority are quite low (1-100 mohms?).
Offhand, I count 343 AlPolys with ESR >= 200mohm, versus 7542 with ESR <= 100mohm, and 616 vs. 4473 for TantPolys, with the same selectors respectively.
Meanwhile, it's backwards for conventional tantalum: 28350 (>= 200mohm) vs. 5178 (<= 100mohm). Most critically, the 0.2-2 ohm (inclusive) range counts 18737, a huge population of very reasonable, and rather convenient, ESR values.
So, as a generalization, it's safer to recommend any poly cap for very low ESR applications, dry tants for medium ESR, and electrolytic for "don't care"/"deal with it". AKA trap for young players: always check the ESR you're buying, and that it's appropriate for your circuit.
Sure is handy that ESR is such an important parameter for these (also rather expensive) capacitor types... selecting (conventional) aluminum electrolytics, for any ESR at all (1.1mohm to 2.3kohms!) reduces the population from 100k to 33k! Not that the ESR rating is all that useful or practical in the first place, unfortunately.
Not exactly, oversimplification. This is very much a function of load, layout, physical distance load to source (power supply),
control loop and sense point of regulation......If talking about just logic would concur. If relays, solenoids, servos, motors
bulk storage very much a consideration.
Ah, but you see where this is going, right?

Those are slow loads, i.e. they only draw current gradually over some microseconds, milliseconds even. The supply disturbance has had plenty of time to propagate upstream, away from any local bypass caps. By the time you start drawing much energy from "bulk caps", the supply itself (whether switching or LDO) is ready to kick in and stabilize the voltage. So, truly, very little energy is needed from the bulk caps, and they're mostly there for filtering SMPS ripple, or stabilizing an LDO (or... damping the PDN).
Or, if you don't have a supply nearby, like a board at the end of some meters of control wiring -- and therefore quite some microhenries away from a true voltage source -- it may be quite necessary to use a large, juicy electrolytic capacitor on it!

And, often, an SMPS is so beefy (10A+?) that you need the low impedance of polymer caps, just to handle the sheer ripple current. In that case, you may have to take precautions to avoid supply ringing (keep the supply impedance low, along the route; or add LRC components at the near or far end, to keep its impedance bounded).
Exactly, and that includes load considerations, passive performance including SRF and beyond,
C vs V in the technology, T......
As an aside thanks for illuminating the beyond SRF problem in paralleling, I have a VNA, plan on
taking a look at this, especially the magnitude of the degradation of ESR.
Regards, Dana.
Ooh, shiny.

Real measurements should be a good complement to such posts as this,
https://www.eevblog.com/forum/blog/eevblog-859-bypass-capacitor-tutorial/msg893314/#msg893314Cheers,
Tim