I drove a "3/4 race" cam for several years as a 20-something. Not too bad, but I wouldn't want to go any more radical than that. "Idle" even at 1500 rpm was lumpy (sounded like it needed a tune-up) and it took at least 2200 rpm just for a normal launch. Kind of tiring to go through at every stop sign or light. If you don't bump the compression ratio up (I was running somewhere around 10:1), low rpm will be even worse.
But it sure was a blast when the cam kicked in around 3500 rpm!
The extra power (combined with my driving style) probably also had something to do with all the drive line components that broke. Limping home with a broken tooth in the differential ring gear was the worst : ka-thunk ka-thunk ka-thunk.