Ever since the Arc Pistol became cool, I think I'm the only person who still has never really cared for it. You know how people hate the Wraith because of how it sounds? That's me and the Arc Pistol.
To be honest, I didn't know it had 'become cool', except possibly on this forum...it has never seemed highly represented in the lobbies I frequent and among my usual in-game compatriots I am the only one to use it regularly (and
always on certain kits, like the Huntress). Even then, it doesn't seem to garner the same devotion around here as some members of what I call the cannon/blunderbuss class of weapons (I.e. the Claymore, Kishock, et. al.)
I have loved it because it so perfectly suits my desires - it is a speed-demon bullet hose that can be a cannon on demand. I tend not to enjoy cannons, generally, but find them occasionally useful; I suspect, however, that most people prefer that quality which is, for me, secondary (or 'icing on the cake, idiomatically). To me, it's like being able to equip one of each, with low weight and no pause for the stilling animation as you switch between them. With those qualities it could sound like The Nightman's beer farts (stop and ponder that sound!) and I'd still be (mostly) in love with it.
ADDENDUM As I consider your dislike of its sound I must, in fairness, admit that I can empathize...I generally dislike the sounds emanating from Krogans and flat-out despise the trailer-park noise of that God-forsaken hammer. In the end, I cannot fault you for admitting an honest aural objection.
...plus, every time I've played with you, you've proven to be an exceptional badass and, let's face it, that goes a long way toward making our differences unobjectionable, know what I mean?