game recs that fit your criteria: Flower Collectors (detective/photography game set in post-fascist italy), Scarlet Hollow (horror mystery vn set in a mining town, unvoiced but not text wall-y by the Slay the Princess devs)

long shot pitch bc I think you'd like it even tho it's an unvoiced cyberpunk vn: Of The Devil is a detective vn/adventure game where you're a gambling addict defense attorney in a cyberpunk setting. smartly written and funny

Baldur's Gate: Dark Alliance. This and the second game are my favorite of all time. It's more of a hack and slash instead of turn based combat. This is a port from the og Xbox and PS 2 so I'm not sure how well it plays.

tales of vesperia is 80% off and has yuri x flynn; light knight x dark avenger/deserter yaoi ans rita x estelle with a socially awkward mage and a sheltered princess and there's a guilds faction vs. empire faction. awesome

v good crpg rec: Pillars of Eternity. real time w/ pause originally (my recommendation) but there's also a turn based mode (ppl who choose this are evil unless u decide to then u are beautiful and valid)