I’ve played Gwent (in Witcher) and I think it’s rather good… it’s “obviously” based on Condotierre, which I really like. It’s basically Condotierre with CCG and ranks, both of which are interesting elements.
The Final Fantasys (I don’t like that pluralization, but here we go) often have significant mini-games. FFVII had a bunch in a arcade-game-location (Sub Hunter, Chocobo Racing, and a few others). Cyberpunk 2077 has a Witcher-themed mini-game (Roach, Geralt’s horse, runs away and has to jump over holes and monsters et al).
The first I remember is an old NES game called… Blades of Steel I think? It had a little Galaga mini-game played on the jumbotron screen between chapters.
Wait. No… uh… periods! Played between periods.
There is a game called Tak that’s based on a Patrick Rothfuss (I believe) game from one of his books, and Player of Games by Iain M. Banks features a man who is very good at playing games who is inserted into a foreign nation’s game tournament to try and stop an intergalactic war. It’s shockingly good. The unreadable and awful Ready Player One obviously features numerous video game references but also a small handful of board games, and of course Orson Scott Card’s Ender’s Game uses a game as a central plot element (wargames, natch, but still).
The original Witcher game had a semi-mini-game where you would sleep with women in order to collect playing cards or… post cards… of the naked women. That was one of the first time I ever played a game and a part of my brain fired and went “Huh… is this a sexism?”
The answer is yes. Yes it was.
Horizon Forbidden West has a battle-chess analog that’s fine (it became a chore pretty quickly, but thankfully a self-contained chore that you didn’t need to play for any reason), and a lot of Star Wars video games have some version of Sabacc but the rules and cards change constantly. My favourite version is basically a fancy version of Blackjack, but you have a small hand of modifier cards (like a +2 or a -1), but only 4 of them you can use over best-of-9 hands. I think it was from the original Knights of the Old Republic? Oh, and Mass Effect had a casino with a version of blackjack (which, eventually, leads to a mini-game where an illegal AI is cheating and stealing money to install itself on a starship).