So far it sits like this for me - in regard to recent RPGs anyway:
Path-err Pillars of Ex- Eterenity - mechanics good, story good
Shadowrun Dragonfall - mechanics good, story good
Divinity Original Sin - mechanics great, story lacking
Darkest Dungeon - mechanics good, story lacking
Age of Decadence - mechanics okay, story good
Underrail - mechanics okay, story okay
Lords of Xulima - mechanics good, story lacking
Shadowrun Returns - mechanics okay, story lacking
Deadstate - mechanics really lacking, story lacking
Wasteland 2 - mechanics lacking, story okay
And by mechanics, I pretty much mean battle/exploration/itemization/challenge/freedom. By story, I mostly mean consequences/choices/party members/world aesthetics/theme/characterization.