There's a particular feeling I chase in Skyrim mods. Not the "haha I'm a god now" feeling from console-tier overhauls, but the quieter one where I forget I left the base game at all. A questline starts, the voice acting lands, the dialogue camera does that little vanilla swoop, and twenty minutes in I genuinely can't remember whether Bethesda made this or some person did it in their spare time over four years. These are the mods that earn that, ranked loosely by how convincingly they pass for paid DLC.
Falskaar. The one that fooled everyone
If you've only heard of one mod on this list, it's probably Falskaar, and for good reason. Alexander Velicky built it in his early twenties partly as a portfolio piece to get hired, and it worked. It's a whole island continent with around 25 hours of content, a fully voiced main quest, side quests, dungeons, a new soundtrack. The tone is pure vanilla Skyrim: Nordic ruins, a power struggle, an antagonist with a grudge. It shows its age a little now (some of the navigation is fiddly and the writing is earnest rather than sharp), but as a structural exercise in "what does a DLC actually contain," it's still the gold standard. People genuinely thought it was official.
Wyrmstooth. The perfect-sized expansion
Wyrmstooth is my actual favourite to recommend, because it doesn't overstay its welcome. It's a self-contained island you sail to via a courier letter, roughly a Dragonborn-DLC-shaped chunk. Maybe 6 to 10 hours. The hook (mercenaries, a dragon problem, a faction with secrets) feels like something the Companions would post on a board. It nearly vanished from the internet for years before being reuploaded, so a generation of players missed it. Don't. The pacing is the tightest of anything here.
Vigilant. The one that doesn't feel like vanilla, and that's the point
I'm including Vigilant precisely because it breaks the brief. It does NOT feel like official Bethesda DLC. It feels like a fever dream FromSoftware crossover, all Molag Bal, Daedric horror, Coldharbour, anime-flavoured bossfights and a difficulty spike that'll humble you. The original voice acting is mostly Japanese with English subs (an English dub exists). But it's some of the most ambitious storytelling on the platform, and the Order of the Vigil deserves more than the two NPCs vanilla gives them. Go in expecting an art project, not a Bethesda product.
Beyond Skyrim. The slow cathedral
Beyond Skyrim is the big one: a multi-team effort to rebuild the neighbouring provinces. Bruma, the chunk of Cyrodiil south of the border, is the released, polished, fully-playable piece, and it absolutely nails the Imperial-fall aesthetic, complete with that Oblivion-era architecture and a dungeon under the city that goes far deeper than you expect. The other provinces (Cyrodiil proper, Morrowind, Roscrea, Atmora) are long-haul projects. I've learned not to hold my breath on release dates, but Bruma alone justifies the install.
A couple of honourable mentions
The Forgotten City started as a Skyrim mod, was so good it got rebuilt as a standalone award-winning game, and the original is still installable. A time-loop murder mystery with real moral weight. And Moonpath to Elsweyr is the ancient ancestor of all of these, the first big new-land mod; it's rough now, but it's the granddaddy.
On install order and expectations
Quick practical note: these are big plugins, so check Nexus for current patches, run them past your load order, and don't stack three new-lands questlines in one save unless you want courier-letter spam at level 3. Most of these gate themselves behind a minimum level or a triggering event, which is part of why they feel official. They wait their turn.
The thing that ties them together isn't budget, it's restraint. The best ones know what a piece of DLC is shaped like and don't try to be the whole game.
So I'll turn it over: which modded quest did you genuinely believe was vanilla until someone told you otherwise? For me it was a Wyrmstooth side errand I'd have sworn was a cut Dawnguard mission.