Ways to deal with this sad fact:
* Ask users "how much would you pay for this?" Follow up with "seriously, if I build it, you'll commit to paying that much?" Tends to bring them back to reality, but doesn't make sense for all products.
* Look for external evidence for user pain. If there is no tool on the market for doing X, but users manage to sorta-kinda cobble together four other products to sort of do X poorly, you can believe that they want X.
* Build quick little prototypes, as cheap as possible, and see what users actually do with them. (You've just done that -- good job :))