I'd say it depends on what makes the game fun.
If the game is about finding your strategy and seeing how it works out then it should be MP. AI can't compete with human opponents.
If the game is trying to tell a story/build up tension SP (maybe with small Coop) is better.
The Following User Says Thank You to Illuminated One For This Useful Post: