Any love for single player custom campaigns?

Specifically, trigger-heavy, in depth story campaigns like Ulio?

For those unfamiliar, the game is a conduit to tell a story, and while rich in dialogue and, imo, the peak of AoE visual experience, it replaces most economic strategy and macromanagement aspects of stock campaigns and RM style games an d heavily emphasized small-scale tactics and linear decision making that contributed to the storyline.

It's been a long time since these were really popular as far as I know, but I'd like to revisit some, and hopefully find a few new ones that people recommend. What am I missing out on?