Totally depends on the car if you ask me, not that I personally care what anyone thinks of the external sound of my engine,
I wouldn't swap the CVT auto in my GS450h for anything else, and the car is quiet enough that neither I nor anyone else has to hear it's engine, and I get the benefit of perfect launches and super low rpm motorway cruising and better economy,
My old Fairlady Z32 TT however I wouldn't dream of having owned as an auto, and cherished the turbo flutter and "wavering" sound of the engine on a hard WOT gear shift.
Horses for courses , I wouldn't have wanted to do a 3.5hr commute in the latter, although I did ...