I am just downright bored of vanilla, especially when mods can ad so much amazing work to the game... but the wide open sand box has gotten a bit boring, even modded, after 10+ years so I really enjoy quest packs that give you a series of goals and accomplishments, and bonus points if its wrapped up on a story.
I kinda miss the way quest packs were in the old HQM days, though.. Modern quest packs, at least the ones i've tried thus far, just seem to be "heres the big wide open soapbox..with checkmarks!" instead of following a storyline and unlocking things as you developed and discovered.