As much as CK2 gave me, I still had to use my imagination to get a really coherent story out of all of it.
I tried to follow a town from the eyes of one character in Stonehearth once, and though it took more imagination - though the mood system did give me a lot more to work with once it was added - I enjoyed trying to fill out the story of the desert mining town of Copperwood. I mostly stopped that because I got busy with school - I still have enough pictures for a couple of updates just sitting on my hard drive gathering digital dust, so maybe I should continue it.
The game has the potential for role-playing and storytelling, but right now you have to do most of the work yourself. Also, I kind of feel like you have to fail pretty bad for an interesting story.