In the game, Morrowind, there was a shack in Sedya Neen. I opened the construction set, took out all the items, and replaced with items I wanted, especially storage furniture and lighting. Sometimes the lighting was adjusted.
I will evaluate the housing in Skyrim to see if there is a house I like. I want a longhouse style, so if there isn't a suitable house, it may have to be modded, using parts from the construction set.
More experienced modders will add different models and textures from 3rd party programs.
Also, I may want to add mods that enhance my character's appearance, such as various make-up, eye color, hair, (Like Ren's) different types of apparel.
My personal taste does not include adding uber weapons/armor, etc., or cheats.
However, Total conversions like Nehrim are acceptable.
To answer to OP's question, I find it enjoyable.