Well, GOG sells a lot of commercial games and doesn’t require online connectivity for anything marked as “DRM free”. Tend to be older.
There are open-source games.
I personally like Cataclysm: Dark Days Ahead, which is a very deep open-world roguelike. Steep learning curve, as a warning, but you can do all sorts of stuff. NPCs, build bases and set up electrical power, build ground vehicles, boats, and rotary-wing craft. Bionics, mutations, skills, music and sound packs, graphical tiles. There’s a build on Steam now, but you can also just download the builds from the dev site for free.
Dwarf Fortress also has a steep learning curve, is a colony simulator. Not open source, but free, also deep, many hours you can spend there.
Shattered Pixel Dungeon is an open source roguelike, relatively shallow learning curve. Really aimed at touchscreen devices like smartphones, but has computer builds, has support for keys and stuff.
Minecraft itself requires an online account, though, yes? Is linked to some sort of central authentication system, needs to be connected to play?