Morrowind offers a lot in terms of modding and is a bigger game than Oblivion, so perhaps it would be an idea to give that a go? You could also play about with the Elder Scrolls Construction Kit that comes with it, allowing you to change different aspects of the world (NPCs, buildings and terrain etc.).