Unique names rarely are the cause for someone prominence.
The only reason anyone ever remembers me is because I am the King of Kink and the Prince of Perverts. They remember me talking about a**l female to male strap-on sex (Pegging). Or my Excapades as a male slut.
A name is a name, and it was probably chosen for a good reason. Somehow I doubt every single name that falls under the category you mentioned was created with prominence in mind.