When you name something, or someone, is it important that the name is unique?

I once lived in a house with three Johns. And at the time we knew like 6 other Johns. So none of them were called John. We used initials usually i.e. JT,JZ,JR etc.

I’ve had several pets.in my lifetime

Dog Wanda

Cats ; Ivan, Megatron,Gilbert, and Bob

A snake named Monty (he was a python, get it?)

Do you care when you name something, or someone if the name is not common? Would you be opposed to a common name if you and your SO were thinking of baby names?

(I realize Bob is a common name, but not for a cat. Plus,his tail is gone, so he looks like a Bobcat. )