Games with the best single player content?: Fighters.
Things like stealing (and getting caught), fighting or killing in towns will change how the game plays as now those people or towns will be angry with the player, which makes things much more difficult. There are also many moral choices in game such as if one should betray the person who gave then their quest by keeping the treasure they were hired to return. All of these things will change.