Angela He has some good ones. I played some time ago 'missed messages' https://zephyo.itch.io/
Also some FMV games? like Late Shift , The Complex , She sees red , The shapeshifting detective
There are also classics like Half-Life or Max Payne that perhaps you could try if finding then in discount.
Also in itch there are some devs that make games with story following a more 'classic' format (not boomer shooters or VN) like revevoodoo and warlines studios many of those are pretty short but entertaining and interesting.
Also, I am making a FPS with story Escape - 1942 now is just the first part, next update will have the full game. Yes, I am a disgusting spammer. Sue me. XD.