I believe The Beatles: Rock Band came the closest to being perfect. Eveything about that game was just beautifully done and the only things missing was Pro Drums, an option for Keys, and a few more Beatle songs (Hey Jude, Strawberry Fields Forever, Yesterday etc. etc.)
Factorio. The game automatically adjusts difficulty based on your speed and familiarity. Pros scaling rapidly are going to have a harder time with biters than a noob learning the ropes on the exact same difficulty settings. Difficulty settings can be scaled up for a true challenge. Mods are supported damn near as much as first party devs. It’s a very well optimized game. It’s just technically impressive, psychologically fun, and fundamentally well balanced.