Dan Smith and Tisha Parti's 2018 One Page Dungeon Contest entry is how effective it can be used as a catalyst for an entire campaign in a post-apocalyptic game setting (or even used in a fantasy setting as well).
Smith and Parti have included lots of hooks and leads including the possibility of a lower level, robotic units, and other buried bases. The awakened sleeper will also likely have extensive knowledge of the past, including the locations that may contain all sorts of loot and salvage. She could emerge as a powerful NPC that could serve in an advisory capacity, or perhaps even a target of rival tribes fearful that her knowledge will give the character's people and unfair advantage. There are lots of directions the game master and players can take after this "campaign seed" is planted.
Nice work Dan and Tisha!