I enjoyed the SP. But it is flawed, and the flaws are in that demo. The destruction and sandbox are quite fun, but the AI is just awful. The friendly AI is worthless, and to make up for the stupidity, the enemy AI has ridiculous aim. You will be milking the injector through the second half of the game.
But it really is worthy of a play through, though for single player it is a rental only.