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

Geez I haven't has a hydraulic cam since the late 90s and maintenance has never been an issue. Easy. Did that same cam swap on the kids Duster 268H to 262S the smallest solid Comp sells. Some Mancini rockers and Smith Brothers pushrods made some more mph and better ets in the same car.
Smaller cam and more performance? I like it.