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)
Back in the day, Warcraft III had a built-in script and level editor and people thrived on making mods and entire new types of games with it (murder mysteries, tower defense, battle royale, DOTA...). It's how I got my start as a coder, modding games that I enjoyed without the boring pressure of "business logic".
I think Fortnite itself has a creative mode with limited logical programming: https://www.firetechcamp.com/course/build-an-escape-room-in-...
Proper modding support is supposed to arrive soon: https://www.pcgamer.com/fortnite-creative-mod-support/