Hmm, pretty tough questions. I remember enjoying it the first time around, but I didn't get far in the story. After a few missions in Balmora, I went to work for a guild. For some reason, I really enjoyed the Fighter's and Rogue Guild missions. They were mostly, go here, kill this NPC, but it felt like I was making good progress. So I'd recommend hitting the big city and joining a guild.