Some input from an application engineer about “low esr”. It appears that low esr is fairly dependent on the application. Power management, RF, LED drivers, etc. In addition to low esr the dielectric is also important ( sometimes specified as X5R, X7R, COG etc).