Unfortunately these things happen even if you do your research previously. I understand your feelings and I'd be feelings the same as I don't like time and opportunity wasted, but as you said, take it as a lesson. Next time you know to do your homework and don't trust the guide either as some can't be trusted.
In any case, I think it's a nice place and definitely worth going back one day.