I love this sort of blend of urban exploration and archeology. I actually made a video game about it, inspired by the "sublime" of uninhabitable (yet comfortable) exurbs of midwestern USA: https://q-andrew.itch.io/anemoiapolis