You are looking for a game to play on PC like oblivion that is not an MMO

Fallout 3, another RPG, is made by the same developer of Oblivion and is currently available for PC.