Besides the already named ones, here a few:
OpenTyrian and OpenTTD were my go-to games for many years. Both are easily found for Mint packaged with free assets.
Minetest, Mindustry, 0AD. I can’t speak for how well they’d run on Core 2 but I think they’d be fine.
OpenRA will get you some classic Command and Conquer. You can run them as Appimages on Mint, and on launch they give they option to download freely available assets.
FreeCiv if you want to get lost in some old school Civilisation.
GZdoom you can play with the FreeDoom assets.
And then there are some open source engines but you need to pair with commercial assets: CorsixTH for Theme Hospital ScummVM can run a whole bunch of older adventure games (some might even be free if you have a gog account) OpenRCT2 for Rollercoaster Tycoon 2 DevilutionX for og Diablo
GZDoom!! There are so many great mods! Search YouTube for some "best" mod recommendations.
If going for more fully open, freedoom is a set of two standalone FPS campaigns(freedoom phase one and two) that also supports doom mods by having free texture/sprite replacments that slot into places where a mod is attempting to use original doom textures/sprites.
For most mods it works well enough but sometimes you'll see a frame of custom animation meant for the original doom monsters.
There's also a deathmatch Wad that works without needing the main doom/freedoom wads, freeDM.
https://www.openhv.net/ is a cool project especially for multiplayer.
https://www.minetest.net/ will probably also run and has loads of cool game mods, not just the Mineclone2 one that is very similar to Minecraft.
I'm a big fan of cataclysm:dda. It's a rougelike, so it needs some time to get good at, but there is a ton of content and I can run on a potato. It's got violence against zombies, but with even the most advanced graphics it can use, it isn't particularly graphic.
Minetest, and in particular MineClone2. Always someone playing multiplayer also which is quite nice.
https://git.minetest.land/MineClone2/MineClone2/src/branch/master/HOW_TO_PLAY.md
Mindustry is good fun also :)
Nodecore is also very fun, you dont have crafting menus and instead you craft stuff in the game world.
It's highly rated. I personally found it quite difficult and a wee bit too frustrating.
Lately I'm having a good time playing Sonic Robo Blast 2, basically an "old school style Sonic game that uses Doom's engine to make it 3D". It's a very polished experience and should run fine on anything.
Another long time favourite of mine is Shattered Pixel Dungeon, a roguelike dungeon crawler that has active development and a great community
Gotta recommend WesNoth https://www.wesnoth.org/
While the nostalgia part is likely lost one someone that didn't grow up with this style of game It's still an excellent strategy game with an almost puzzle like feel to it. Bonus points for being in development for longer than you've been alive as well I feel ;)
I like Endless Sky - a free and open source space trading, combat and adventure game.
Rimworld is only as explicit as you make it. I mean I guess people try to kill your people, so there's blood, but non of the war crimes are requirements just emergent gameplay features.
https://veloren.net/ - I couldn't find system requirements but maybe that will help to run it.
https://libregamewiki.org/Main_Page
Maybe some older games that don't require downloads: https://archive.org/details/internetarcade
As some that used to use an equally potato PC before, the most recent Veloren updates might be hard to run at a playable level, even on the lowest-possible graphics settings (Veloren's community and devs are doing an awesome job adding stuff and making the game better every month!).
But if you don't mind the terrible graphics, low FPS, and frequent slowdowns, the game is still very much enjoyable. I was a low-FPS gamer for most of my life, so bad performance never stopped me from enjoying to play a game!
Even if you're not running Linux, check out the archwiki:
https://wiki.archlinux.org/title/List_of_games
These will run on pretty much anything, and many of them are fantastic. Check this out!
factorio and stardew valley.
games like pubg csgo and fortnite might run if you have a video card and 8gb ram.
hell, many AAAs from the ps3 era will run fine depending on your video card.
So you're saying you want free games with explicit content? I'm sure Bible Black would run well on it.
(Yes, I'm kidding.)
Xonotic.
Great arena shooter all around even excluding the fact that's FOSS. Used to play it with a 2012 Intel i5 and HD 2500 integrated graphics on 1080p medium settings and was averaging around 80-90 FPS on default maps.
Now I don't know what kind of GPU do you have, but I bet that it would probably just fine on low settings and maybe at a lower resolution.
Another thing worth mentioning is that you may have trouble finding populated games with good ping if you live outside of Europe.
Noita would probably run on that. Amazing fun game
I personally really like osu! and it's available as a flatpak for linux (you should be able to just install it through the software install thingy)
Super tux kart Battle for wesnoth Shattered pixel dungeon