Diablo 3 was amazing for that; can vouch, especially on console (even if I mostly prefer the PC version for being able to rack up larger kill streaks), and especially if you have a partner to drag in for local co-op.

Here's my go-to list of "comfort" games:

1. Vampire Survivors. Once it gets its hooks in you, kiss your night goodbye.
2. No Man's Sky. The building system is a little clunky, but there is so damn much to do in this game, especially if you make a beeline for the storyline missions or do an expedition ("seasonal" content). It's like Ark or Rust, but in spaaaaace
3. Skyrim. Best played with a handful of quality-of-life mods (Unified Skyrim SE Patch, Alternate Start - Live Another Life, SkyUI) and some kind of funny build shenanigans in mind so you don't just end up doing stealth archer for the 69,420th time.
4. Stardew Valley. Can you complete the community center before the end of Year 1? Can you establish a People's Republic of JojaMart and keep your hatred of Pierre pure? Can you start a PoWeR dYnAmIcS struggle session about the ethics of your avatar in-game dating a 21 year old?
5. Octopath Traveler series. OK, full disclosure, I grew up on NES and SNES-era JRPGs, particularly Final Fantasy IV, VI, and Mystic Quest, Super Mario RPG, Chrono Trigger, Destiny of an Emperor, Dragon Warrior ("Quest" #1), so this shit was catnip for me. The original OT1 is a little unrefined, but solid if you're into that sort of game. OT2 is streamlined and introduces a lot of quality of life tweaks, and you don't need to have played the first one to enjoy it. Start here if you're not up for getting thrown straight into the missable achievements meat grinder. OT: Zero is game of the year material, according to a certain amateur wrestling transfemme enby gaming media personality whose ADHD should be reason enough to avoid anyone voluntarily being employed by her, but otherwise whose opinions I generally trust. (I haven't played more than about an hour of Zero yet, but the nostalgia bait is definitely there. It's next on my list.)
6. The Legend of Zelda: A Link to the Past (Randomized). https://alttpr.com/en -- I got into this on account of my spouse showing me Griffin McElroy's "Trial by Fieri" playthrough and thought it was hilarious. Pro tip: play with the Mog sprite from FF6 so no one can spike your cortisol levels. This one is good for learning to do glitchless speedruns, usually in the 4-6 hour range per playthrough.