I'm not a fan of aftermarket exhausts, stock one is plenty loud for me and doesn't disturb anyone while I'm riding normaly. I especially dislike the grandpa chopper bikes that sound like tanks, like you said my sports bike gets insane at >9k RPM - but I don't ride insane in populated areas.
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.
I understand many people put the aftermarket pipes "for themselves", at least consciously, or at least claim so - but I feel at best, it's a degree of self-centerdness to not realize impact on others. I see it on Subaru forums too - fellow WRX/STi owners moaning about their neighbour's complaints and cops stopping them and people giving them dirty looks etc etc - obliviously blind that it was themselves who brought in on by installing ridiculous loud exhausts. A factory exhaust on my bikes gave me plenty of thrill, and while I did put a high-flow cat on my Scoobie, I searched for an exhaust with nice sound but quieter actual dBs than stock. Few things are B&W - but there is a loudness at which point it really really is about others.
(note that when you say "past 10k RPM", it sounds like you likely have a sportsbike, and as you say a stock one; those can be loud at high revs, but generally speaking the loudest bikes in my experience tend to be modified cruisers and wanna-be Harleys.
Also note that rider may not always get straight opinions from friends, depending who wants to fight what battle when - e.g. last summer, a rider was revving his throttle at a friends' cottage and boasting about his aftermarket pipes; given we were both guests, I politely nodded and meandered away... but everything for the rest of the evening confirmed the image I formed the moment I heard his pipes :-/)