I like
Mary on other people but would not personally use it. I find it classy but not quite interesting enough to attract me personally. I know a
Mary or two and it has never seemed at all odd or out of place that it would be their name.
I detest
Marie and
Maria for the same reasons that I don't like
Lynn and
Renee. I've almost heard them exclusively as middle name "filler," like middle names given to a child because that's what everyone else was getting and the parents didn't have enough imagination to branch out into anything else.
I like names that are related to it or derived from it, though, more than
Mary itself. Some of them would include
Maire,
Molly, and
Miriam.