I'm playing Torment: Tides of Numenera right now and it's pretty good, though the way I'm playing it, it's more an adventure or visual novel than an RPG. I think GOG even put the game under the Adventure category instead of RPG

I haven't had an actual battle since the prologue, so I can't really say if the battle mechanics in this game are actually decent, if you plan to make a combat build.
And yeah, Dragonfall is the best out of the three Shadowrun games. I never finished Hong Kong, though I suppose the reason for that was simply fatigue. Hong Kong just ain't much different than Dragonfall and I guess I got bored. I'm gonna finish it one day though. It was a good game regardless.