The thing is, if someone comes on here and asks what various people on the internet think of a name, presumably they want to know. If you ask people's opinions, I suppose you must be prepared to hear them, even if they are very negative.
Obviously we all like different names otherwise everyone in the world would have the same name. I'm sure many of us have idiosyncratic reasons for liking or disliking names. I've seen DS2's name described as 'yeuch' or something similar on here, and DS1's name is often slated by people.
I think Honey is a daft name. I think it's a bit like calling your child "Sweetie" or "Darling". I don't much like it as an endearment either.
As it happens I don't much like Honor either. But I don't think it's daft.