I started going by my middle name Marica (pronounced Mah-rye-kah) when I moved back to Calgary as there were quite a few other Amanda's in my school when I previously lived there. Marica is a Dutch version of Mary and the name my father, who is from Holland, chose for me. Though my dad continues to call me Mandi.
As we consider all our pets our kids, we've chosen mostly human names for them all. Our dogs are Leisha, Timmy (named Timon by his previous owners), Connor (Butch prior to us adopting him) and Logan; our cats are Fiona, Caiden, Nevan and Liam; and our corns are Keenan, Naomi, Athena and Helo (got a little carried away with our love of BSG with the last two). My partner is Irish hence a lot of Gaelic names. I also had two hamsters growing up that I named Jeffy and Casey, and two gerbils named Percy and Reggie (my mom always had Coronation Street on).
Not sure that I can think of anyone with a spectacularly 'cool' name that I've meet, though what someone else may think is cool, you may think is ridiculous. I got a baby names book when my mom became pregnant with my brother and have many names circled that I thought were cool at the time, but not so much anymore.
I do have one to add to the bad name combos: a vice-principal at my junior high school was named Harold Weiner...why he chose to go by Harry is beyond me.