Obviously you need to check my metroidvanias collection.

Though since the collection is for any metroidvania I've played and confirmed, their playtime varies from short, mid to long. And also some of my games are also there so I've warned you before browsing the collection.

Do you want my recommendation from the collection?

Heroine's Quest is a great adventure game. It's like Quest for Glory so the game focuses on exploration and the world is pretty much fully open from the start, another main hook is that you pick a class in the beginning which defines how you'll solve many puzzles, and there's some combat.

One traditional one (without combat) I enjoyed and whose focus is also on exploration is SPECTACLE.

The Garden Path – Relaxing exploration game with pretty visuals and gentle puzzles.