Some folks may want more sound (for example, a HD "potato-potato" sound which, BTW, isn't going to happen... maybe Ducati, but not HD).
Some may want more performance. BUT...very few pipes provide
significant performance improvements without additional mods to the air intake and fuel injection systems. In most cases, louder is perceived as faster.
Some may just want to be different (like me). I've used the stock, Micron, Supertrapp, Hindle, and Yahama Warrior pipes. I like the Warrior best even though it is very quiet and looks like a chrome 155mm Howitzer hanging back there.
If 100 folks answer, you'll have 100 different opinions. These are mine and I'm stickin' to 'em.
.
.