I haven't played it but I here Elder Scroll IV: Oblivion is pretty awesome and sounds like what you are looking for.