Not that they're particularly funny names, but our two cats are Monster and Dio. People usually ask if Monster lives up to her name (um...yes, sometimes). And for Dio, we often get a funny look and "You named your cat God?" (no, he's named for DH's favorite singer, Ronnie James Dio). It was ironic when, making a vet appointment for him this year, the lady had some difficulty with his name and called him Diablo.
Our next pet, dog or cat, will be Bowie, but we often joke that if we get another cat, we're going with Katt.