I have a roller, the reason being I didn't want to pull the engine and start over if a flat tappet cam failed. I know flat tappets are dependable and very few fail, but I wanted the piece of mind.
I can relate to your cam woes, everyone wanted me to buy their wild cams even though I told everyone and their dog I wanted a street/road engine not a race engine.
This all boils down to cylinder pressure. More pressure, more power. More pressure, more potential for detonation. All the talk about static compression ratio means little to me, as a low static C/R engine can make more pressure, depending on valve train, than a higher static C/R engine. All your engine parameters are locked in, now that your finished building, but the valve train can be changed without a rebuild. Determine what pressure you, and your fuel, can live with and select a cam that will give you that pressure and still have the manners and performance you want. Not an easy thing and I'm sorry I can't recommend a specific camshaft grind.
I also wanted low end torque which is why I chose the 230/236, if I'd paid a little more attention to pressure I would have gotten one just a little larger, and may change out to a 236/245/112. That cam seems to be a favorite with the 455 owners over on the lower mainland.