There's loud pipes, and then there's LOUD PIPES. I'm a motorcycle rider with an aftermarket exhaust, but I didn't put it on to make it louder, I simply prefer the different visual look of the aftermarket exhaust (undertail vs underslung). The new exhaust is slightly louder (~5dB) and has more of a bass characteristic, but it's certainly not obnoxious. Do I get noticed more? Yes. However I also know I can start my motorcycle at 7 in the morning and go for a ride and my neighbours aren't inconvenienced (I've asked them), so it's not a black or white situation.
I think most riders are in this camp as well - they just want their bike to look and sound good (good!=loud necessarily), rather than be obnoxious, but there's a small number of riders that just want volume for the LOOK AT ME factor. I'm 100% against those folk - they're just being selfish and spoiling it for everyone else.