Good offline RPG for me ?

If you don't mind it being a bit difficult, you could try Demon's Souls for the PS3. Other outstanding games would be in The Elder Scrolls Series such as The Elder Scrolls 3: Morrowind and The Elder Scrolls 4: Oblivion. If you prefer action RPGs, then Dungeon Siege 3 was just released and is much like Diablo.