The title of this thread suggests that's the OP is saying that single player only games can't be great. If that's your opinion then I respect that, but for me some of the best games I've played have been single player only games.
Is defiance a great game? Sadly no. Ignoring the bugs, this is an average game at best. Personally I feel the game lacks depth and not having a real sense of progression is an issue to me. Lets face it, we'd probably all stick to that one great gun we liked if we weren't forced to change it because we had maxed out its exp. That is not progression!
The menu system is also clunky and inventory management is hellish. When going through my inventory I'm actually interested is knowing what's equipped to all my load outs and not just the currently selected one. Since the game doesn't tell me this then I have to try and remember every piece of equipment I have equipped across my load outs when comparing new gear.
Despite all this I still enjoy the game for what it is, although I fear that I will only keep playing it as there are no other games that interest me coming out any time soon.
Oh and regarding Bioshock Infinite - I'm with the others who say that games a masterpiece. But even that game, like all games, has its flaws.

