The Boys is about non-superhero characters in a superhero universe, pretty much matches your post question. The core group of people ("The Boys") start out as regular people living in a world being trashed by people with superpowers.
As the series progresses it does veer off from that but maybe the first season is closer to what you're looking for.
Linux would make more sense but if you're dead-set on Windows then I guess you could try Win 11 Pro (or Enterprise) with whichever debloat tool you prefer. I've had good experience with Win11Debloat (https://github.com/Raphire/Win11Debloat).
Don't expect too much with 8GB RAM but at least you can start out removing the AI stuff, Windows Store apps, etc. to trim down the bloat. Be prepared to have to re-run debloat scripts and/or re-install Windows, Microsoft likes to add new types of bloat post-install.
And keep an eye on any and all apps and services that are configuring themselves to auto-start on Windows boot, you don't need any optional stuff to auto-start and take up memory in the background if you're constrained to 8GB RAM.