Look up project brutality or brutal doom. Those are great doom mods with a lot of fun gameplay. I used to play that for hours.
The Anno series is pretty cool. It's like playing crack. I've been playing 1800 recently and it feels like an instant classic.
The elder scrolls games are great for this. The further back you go the more replayability there is IMO. Morrowind is goated.
Dungeon keeper 1&2 are both a lot of fun, and have lots of custom maps. The original dungeon keeper even has a full engine rewrite which is really good.
If you want to try map painters, Crusader Kings 3, EU4, and Victoria 3 are all excellent and in depth games, with a lot of replayability stemming from all of the different ways to build up your nation in the sandbox.
Rimworld, dwarf fortress, etc. Have fun!