Yes, but with a big but at the end (that sounds a bit weird doesn't it). For example, 6 of my all time favorite games: Mass Effect Trilogy, Skyrim, Fallout 4, & Fallout New Vegas. I wouldn't even think about playing those games now without modding them. The vast amount of mods for those games (especially Skyrim & FO4), allow me to improve those games radically, whether it be textures, weather effects, improved water, better AI, combat improvements, new areas, new quests, ect. If you want something, chances are there's a mod for it.
But, all those games are great just as they are, and the first time I played each of them, I played them without mods and loved them. But after having played them with mods, I could never go back to the "vanilla" version.