That is the often thought philosophy. It is a small amount of ESR, which dissipates the noise energy as heat, rather than dumping onto the ground plane and causing ground bounce. Sure, a cap with large ESR can cause a spike on the chips power pins, what is needed is a small amount of ESR in a bypass cap to dissipate that spike as heat.
Some large computer back planes have shunt VHF caps in series with a 1 to 10 Ohm resistor to ground just to keep the power plane resistive and lossy at higher the frequencies where typical bypass caps have gone through their internal self resonance.
For series DC blocking caps, then, yes I totally agree, the lowest ESR cap is best.