Wilmot's Warehouse is a game that really hooked me good. https://store.steampowered.com/app/839870/Wilmots_Warehouse/ $7.49
It's a simple game all about organizing boxes and filling customer orders in time. I'd sort of compare it to Paper's Please in terms of just you doing a job and it getting more and more stressful.
Return of the Obra Dinn is a game I fucking loved. https://store.steampowered.com/app/653530/Return_of_the_Obra_Dinn/ $13.99
It's a weird concept all about just piecing together what happened on an old ship with a mysterious history. There's no real linear path and very little hand holding. You just explore the ship and start putting names to faces. The goal is to figure out who everyone on the ship was, what their position was and if/how they died.
Hypnospace Outlaw is another unique type of game if you're seeing a pattern in my list. https://store.steampowered.com/app/844590/Hypnospace_Outlaw/ $9.99
You play as a moderator overseeing a very old school version of the internet. It starts out finding copyright infractions and people flaming, but there's a bigger story that comes out the further in you get. It can hit pretty hard if you have any nostalgia for 90s internet. They really nail certain parts.
Pyre is a Supergiant game I never see get enough love. https://store.steampowered.com/app/462770/Pyre/ $4.99
It's a cross between a visual novel and a sports game like basketball or football, but with super powers. Real good story and a great soundtrack. It's the game that came before Hades, which I also couldn't recommend enough and you can see parts of it in there. But this is all about gathering members for your team, playing matches and winning the season. There's a pretty big turn as far as the progression goes, but it's better not knowing ahead of time.
Adios is possibly my favorite "walking simulator". https://store.steampowered.com/app/1271400/Adios/ $13.49
A great game. Very short. Somewhat hard to recommend at the price, but I do think it can be worth it if the story hits you hard enough. You play as an old man who owns a farm that is paid to dispose of bodies for the local mob and you're calling it quits. The majority of the game is spending the day talking to a hitman you've been working with, doing chores around the farm while you discuss if you want to quit or not. If that premise sounds interesting enough to get you hooked and you don't mind the price for roughly 2 hours of a game, I highly recommend giving Adios a go.
Stories Untold is basically a horror game anthology. https://store.steampowered.com/app/558420/Stories_Untold/ $1.99
Another weird one hard to explain. Each "episode" acts as its own style of game. The first being a play on classic text adventure games. Each episode offers something completely new and the less said the better I think. I think this is a must try if you have any sort of love for classic types of horror. It's not a jump scare game and is more about building tension and dread. If you have any sort of love for old horror anthologies it's 2 bucks! Buy it!
Her Story is my favorite FMV game where you piece together a mystery. https://store.steampowered.com/app/368370/Her_Story/ $2.49
Love this game. The entire game is you searching through a police database and watching recordings of interrogations. You are given nothing to go on and there is no way to browse. All you can do is search for words that appear in the videos. You watch the results and slowly try to figure out what the hell is going on. Who is this woman? What is the crime that happened? Who is the victim? What the hell is going on? I actually recommend playing this with a pen and paper next to you so you can take notes on keywords to search for. Names, places, dates, events. Each little drip of info can lead to uncovering some major plot points. For that price I really think everyone should just give it a chance and see if you enjoy it. There's another game that came out called Telling Lies which isn't connected in any way to this one, but the gameplay is similar and I highly recommend that as well (though also suggest you add a mod that allows you an easier way to play recordings from the start). The creator's next game, Immortality comes out in a month and I'm pretty psyched to play it. But so far I think Her Story is the gold standard.
So not really very obscure games no one's ever heard of by any means, but they might have flown under someone's radar here and I think they're worth checking out. I think they're all different enough from most of the games out there and it can be great to experience something new.
Other games I absolutely love and always highly recommend: Disco Elysium, Hades, The Stanley Parable.
Obra Dinn is on my wish list now. I already own Hypnospace Outlaw on Xbox. I own Stories Untold, Disco Elysium, Hades, and the Stanley Parable too. Waiting on a discount on the new Stanley Parable game also.
I did purchase Her Story and Adios though. Thanks for the recs!