That scenario has played out many times for me, when I lived in Japan. The most upsetting time was when I decided to explore a large bamboo forest, outside one of the small towns I taught in. Once inside, I discovered an old, abandoned neighbourhood made up of a few streets and homes. It was as dark as night in there, as the bamboo was quite tall and thick. The houses were most likely constructed shortly after the war. An infinite number of photographic compositions jumped out at me. I rushed back to the train station, planning to return the following week. A week had passed, and I returned with my 4x5 camera. You can imagine my surprise when I found the entire area had been leveled to make way for a new development. My jaw hit the ground. It still bothers me to this day.
The list of challenges/failures is long, but this one is top of the list!
Welcome to the forum!