@swan_tower Many recs here for The Talos Principle, which IS an incredible thought providing puzzle game, but short it is not.
If you're looking for something relatively short with a fantastic narrative that uses its gameplay mechanics as part of the storytelling, my #1 pick is:
Brothers: a Tale of Two Sons
Absurdly good game. ~4hrs long, very polished. Highly recommend you play it if you haven't.👌
@swan_tower You're super welcome - I hope you enjoy it as much as I did! 😄
Talos has a great meta-existential narrative, while Brothers has more of a compelling emotional narrative.
If you'd like a short, solid narrative-driven puzzle platformer that'll make you ask the question "why do I care so much about these rectangles??😭" I'd also recommend:
Thomas Was Alone
VERY skilled narrator in that game. 👌