I did a couple vanilla runs, then activated the console and did a couple god-mode cheat runs/half-runs. Then got intrigued by mods and installed a whole bunch of them. Played around with them for a while, but most mods, IMO, tend to either dilute the full gaming experience or theme with a large amount of extraneous and superfluous content (Winter Forge, I'm looking at you) or are vastly overpowered (most weapon and armor mods that are not adult-natured).
Now, after a break from the game, I tend to run very close to a vanilla game, relying on official DLC and core-game items for my weapon/armor, with only a few mods to carefully and unobtrusively enhance gameplay (Quinn's Fixpack, Extended Inventory, Better Two-Handed Talents) and a single cheat mod remaining (Talent Books) for rare occasions. Haven't even activated the console since my last uninstall/reinstall.
My current opinion of mods is that texture/reskin mods or large-scale game-changing mods, are generally to be avoided (and I run at the lowest graphical settings anyway, so are mostly irrevelant to me), extra content like missions and quests are worth trying if they seem to have some effort behind them, and merchant/item mods are almost always too overpowered to interest me anymore (though, a dwarven massive armor set other than LoD set would be cool, using the skin from the DN origin armor)