I have been on a kick lately with short games. Because I'm a parent with a hectic job, it's really nice to be able to beat a game in just a few days.
I've played both Plague Tale games (10 & 20 hours respectively), Stray (7 hours), and Alan Wake (10 hours). All great stories, very atmospheric, and felt like just the right length for what they were.
Any other good story-heavy games that are pretty short? Throw any and all recommendations at me!
Returnal, Resident Evil REmakes, most Giant Bomb games, Firewatch, Hellblade...
If you liked Alan Wake, definitely give the RE remakes and Hellblade a shot, and don't sleep on Firewatch. In fact, Hellblade: Senua's Sacrifice is probably one of the most thoughtful and atmospheric experiences in gaming (at least in the field of 3rd person, pseudo action games).
I second Resident Evil games. But, they have multiple ends that require replay the games or a large portion of them. You can watch the endings on YouTube though. But iirc, RE VII, has a whole different portion of game influenced by a choice you make, than make you replay that whole part and it can be long.