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 :-/)
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.
In a different lifetime I had a few bikes including a TL1000R that was just plain intoxicating to ride with aftermarket pipes.
There is no way in hell I could do that to my neighbors at this stage of my life, however, and I often cringe at the actions of my younger self. Nowadays, I refuse to even use gas powered garden tools for noise (and environmental) reasons.
I almost buy the “loud pipes save lives” angle but if you need to deafen others to protect yourself maybe motorcycling just isn’t an institution worth keeping around. That said, I don’t think it needs to come to that.
I regularly get small children approach me on motorcycle and want to pull the throttle, then get scared, then want to do it again, there's something primal about that, it's (mostly) not about other people.