Does anyone have recommendations for novels, movies or video games with that topic?
https://windupstories.com/books/pump-six-and-other-stories/
Also I guess Silo / WOOL by Hugh Howey is perhaps closer to what you wrote literally but probably not quite the vibe maybe.
It is self-indulgence, because we can see similar fantasies in people with other skills; people collecting guns often secretly long for a collapse of law and order, people who live in the countryside and have horses imagine themselves to be cowboys in a car-less world. People who like to tinker with old cars imagine Mad Max scenarios. Et cetera. None of these scenarios are especially likely to occur; they only persist in people’s imaginations because many secretly hope for them to come to pass.
In general, you should look into the ‘solarpunk’ genre, especially post-apocalyptic solarpunk.