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

I've been dancing around in my head about the type of cam to use for the 440 build going in my D200 pickup which will see moderate (5000-8000lbs) towing. I'm leaning away from HFT due to recent hydraulic lifter quality issues. Considered hyd roller but they're frickin expensive and I don't feel great about converting to something that was never offered from the factory, now I'm leaning toward a solid flat-tappet. Comp has the XS268S with an advertised power range of 1800-5500 RPM which sounds just about perfect or I could go with a custom grind. Price of SFT cam, high-quality EDM lifters and factory-style ductile iron adjustable rockers is still a few hundred less than a hyd roller cam and retrofit roller lifters.

And I've just always wanted to build an engine with a solid cam, dammit! Lol... Heard a rowdy SBF with a solid cam when I worked in a hot rod/race car shop and I was mesmerized, that sewing-machine sound is like music to my ears. I don't get many chances to build engines so there's no telling when I'll get another opportunity to put a solid cam in something. 360 in my Duster has a Racer Brown custom-grind hyd roller and it works fantastic but I used a junkyard 5.9L Magnum short block so I was able to reuse the factory roller lifters and 'spider' retainer, saved me like $600 in that case.