I think there's a slight distinction to be made between "games that have built-in low/no-code content editors" and "games that can be modded via an SDK, but you have to code".

The former are good for any creative kid (or adult!) and don't require you to learn a programming language, just logical thinking (as in logic gates/flows). The latter, depending on tooling, can require everything from simple Lua scripts (a common game modding language) all the way up to learning UnrealEngine or Unity.

Games with built-in content editors:

* Warcraft & Starcraft series (oldies but goodies)

* Fortnite

* Minecraft

* Neverwinter Nights series

* Divinity: Original Sin series

* Age of Empires series

Code-moddable games: Too many to list, see here: https://store.steampowered.com/tags/en/Moddable/#p=0&tab=Top...

In particular I'd check out Warcraft, Neverwinter Nights' DM mode, and the DOS editor for a good sampling of what the industry can offer. They are a great stepping stone to actual programming, with triggers, conditionals, and other flow control structures all wrapped behind a veneer of fantasy gaming.

(edit: sorry for potato formatting. no idea how HN handles text formatting)

Overwatch's workshop might be a fun introduction.