This one hits close to home. The last bloated game I played was Assassin's Creed Valhalla, and I could not finish it. I haven't touched a 40-hour campaign game since.
The only die-and-retry game that I can play now are Souls game, and they take a toll. Otherwise, unless they are very forgiving (e.g., some roguelites like Hades), I have to skip them.
Here are a few games I liked, just in case you find one that fits your tastes, don't hesitate to share yours :
Shiren 5+, that's a roguelike, pretty old series, very interesting mechanics, and rewarding
Dead Cells, roguelike, 2D action, one run is less than an hour so it works well
Brigandine, Strategy RPG, one campaign can be done in 30 hours or less and it is very fun, zero bloat
Star Ocean 2R, excellent remake, super fun, fast pacing, choices, no bloat, not too long (30 hours)
Valkyria Chronicles 4, excellent Tactical RPG, no bloat or very few, you from battle to battle, respects your time (40 hours)
Dead or Alive 6, only fighting game I can still enjoy, great AI, easy to play
Sonic x Shadow, action platformer, Sonic games are usually really fun and pretty short, you can replay them, this one is excellent
Project Zero, great game from KT, dark atmosphere, scoring system, one stage is less than 1 hour
Streets of Rage 4, excellent beat em up
Catherine, Outer Wilds, Talos Principle, The Forgotten City : all interesting puzzle/mind games
Witch on the Holy Night is my favorite recent VN, Steins Gate (original game) is a must play as well
Metroid Prime Remastered, amazing game, looks very good, not too long, exploration