Dan, for street you want a torquey engine to get you rolling off street lights and stop signs. Some of the commenators here live with HP up their hoop. Fine for them. A big HP engine will have a cam that provides higher RPM torque. That with higher RPM gives a higher HP figure, and that high HP allows you to drive at 150 to 200MPH. Not exactly street.
Then the arguement goes to a torquey engine making you smoke the tires every time you step on the throttle. Well maybe if you have no filter, but judiscious application of the loud pedal controls that. A torquey engine allows use of taller rear gears which enables better fuel economy. A torquey engine in a truck allows pulling a trailer with less throttle opening again giving better fuel economy.
If you go to show and shines and to the strip a couple of times a year, more gear can be tollerated.
The "RV" cam designation came about as the design gave slightly more duration and lift than the OEM cams, which allowed easier hill climbing in motor homes and trucks pulling a holiday trailer. Then motor homes and trailers got bigger and that market moved to diesel engines, and diesels provide great low RPM torque for those working applications.