Single player, if you have an active imagination it can be quite fun. It is not easy however.

Making decent (I am not talking about high ratings) MP levels theese days is much harder than you think.

Also, may I ask what other games you're planning to make levels for?