Yes, playing against the computer can be fun especially if there is a good plot like in RPG games. Plus, I do not have to be online to play against the computer.
It depends upon my mood and the specific game. There are are some games that are better in SP than MP and vice versa.