At What Point is a Solid Cam Better Than a Hydraulic Cam??

I have never had an engine on the dyno with a solid lifter cam, and after testing was done thought to myself.......
“Boy, this motor would have been better with a hydraulic cam”.

On the other hand, I can’t say the opposite is true.
I’m usually left wanting more when the engine has a hyd cam.