MP 509 cam

The Pruple 292 cam can still perform well. As others LOVE to rant the words, "Outdated" a lot as if the cam can not perform is ridiculous. Though the other half of such statements are true. There are better cams made today that will perform better for street vehicles.
The Purple cam makes for an inexpensive (budget) street strip cam.
It'll power a car into the low 12's with the correct parts.

I myself went to a Hyd. roller cam on my current 360 and solid roller on the next future build. It has been an expensive upgrade.

Many ask why should I spend 3 times the cash on a cam and still have to spend another (nearly) 2 times the cams price for lifters?

The roller cam has a few advantages that start to add up and the further you dive into a more and more powerful engine, these advantages start to add up and show themselves well.

The biggest two would be the abilty to really lift the valve a lot. The other is the abilty to have more area under the curve (duration @.050) to cram more air and fuel into the engine.
3, just the rolling action of the lifters instead of the high friction sliding tappet is HP.

I think so very much you will be happy at the performance of a roller cam over the flat tappet.
I don't think you will enjoy the price tag that goes with it.
An excellent compromise is a solid lifter cam. Not so expensive, and aggressive lobes are available. Investigate these areas starting with Hughesengines.com. Comp, Lunati, Crane, Bullet cams are other places to look at.

Hyd. = Inexpensive & reliable
Solid = more money but more power and RPM.
Hyd. Roller = expensive, reliable
Solid roller = Max power & RPM.