Sounds like an obvious question, but have you looked for shorter story driven games?
I struggle with longer games too, with Elden Ring and TotK being the only 50 hour plus games I’ve played in the past 2 years.
Stuff like Miles Morales, Lost Legacy, Ori, A Plague Tale have been excellent for me as they’re all 6-12 hour experiences.