I dont buy MP only games so if Demigod is just MP then I wont be buying it.
Also is it as good and have a lot of stuff in SP as it does in MP if it has SP?
Yes, there is singleplayer in Demigod. Great way to learn the ins and outs of the different characters and items and maps.
That said here are the differences between singleplayer and multiplayer. Gameplay is exactly the same. Here are the differences:
In singleplayer you have to play against the AI. Which has seen improvements over the past few months but still makes dumb decisions/stands around for no reason from time to time/etc. There is some merit to playing the singleplayer in that you control all aspects of the game. If you never play multiplayer then of course you would be ignorant of human play tactics which could be a good thing because the AI then doesn't come across quite so 'dumb'.
In multiplayer you have the chance of meeting up with people who think they are 'pros' and will flame you the instant they realize you are new to the game. You also have the chance of playing against people who would try to exploit their stats by desyncing the game if they are losing against you. Basically, you are taking the chance of having a really bad experience every time you play a multiplayer game. On that note, however, there are lots and lots of good players who are either helpful or patient or understanding, etc with you and you could have an enjoyable experience.
In my book, the absolute best Demigod experience is in a LAN situation where you know everyone and are assured a good time whether you win or lose. The 2nd best Demigod experience is to (over time) make friends in the Demigod community and try to team up with those people (or play against them in friendly competition) at every chance you can. The 3rd best Demigod experience is playing against the computer AI to test different builds and game settings.
At the current price (50% off) it is a MUST HAVE no matter what experience you are looking for.