Thanks for sharing your experience. Yeah for the first couple of times I was heartbroken (It still happens), but now I've learned to embrace it. Nowadays when I have an idea, instead of asking the same dumb question to people "Would you use this?", I try to build an MVP as quickly as possible and let the product do the asking, and users answer with action instead of words.
Like Steve Jobs said, people don't know what they want. This is not a condescending comment, it's a great insight that comes from being able to understand how human mind works.