My middle name is Agnes and although I've always hated it, I recently fell in love with the French pronunciation, "ahn-YES" to me this sounds so elegant & beautiful, I no longer dread the day that I'll have to decide whether to carry on my family's tradition of having Agnes somewhere in the first daughter's name. I might even make it her first name now that I've learned such a beautiful pronunciation!
In Denmark we pronounce it OW-ness, with the ow sounding like en how. While being an old name and quite uncommon today it's not considered ugly in any way but that may be because of a character on a Danish show called Matador who was called Agnes. She was a beautiful, complex and very strong character so the name is, for a Dane, closely connected to her - and therefore something positive. Needless to say, I therefore like the name (and prefer it in Danish).