Some scaling issues aside, I think Oblivion struck the balance well. Modded oblivion was the perfect RPG experience for me. Felt I was truly immersed in an adventure.