Yes, as said, try exploring the world of indie games. There are many popular and well received indie games.
Also in steam you can try exploring games with tags such as "Adventure", "Story", etc. Look at some popular SP games and their tags to explore more.
Brothers : A tale of two sons
Stardew Valley
Don't Starve
Gris
Grow Home
Braid
Fez
Child of light
Valiant Hearts
The Last Campfire
The Gardens Between
Superliminal
Try Stray, while the story is short and can be finished in 6-7 hours. Its a game for the weekend. Although it was released in 2022, it can run on hardware that came out a decade ago.