Everyone knows that the perfect capacitor to decouple the power rails around ICs is a 100 nF ceramic capacitor or equivalent, ...

External, discrete capacitors have non-idealities that can be critical. There is a parasitic Effective Series Inductance (ESL), and a parasitic Effective Series Resistance (ESR). Both ESL and ESR ...