Things are usually on a spectrum and not binary; I agree that part of the thrill of ride is the sensation - vibration, noise of wind and engine, gravity forces, etc - and certainly manufacturers of both performance bikes and cars frequently tune the engine and particularly exhaust for desired image and sound.

I still maintain though that there is a wrong side/portion of that spectrum, and that e.g. a straight pipe on a Harley does far more negative impact on others than positive impact (real or perceived performance, rush, etc) on the rider.