How often do you place planetary defensive structures for your colonies? Do you think they are necessary?
Depends on my situation and what I'm defending against. The best defensive structure is, hands down, the repair bay. Not only does it improve every other defensive structure by making them harder to kill, but it also provides a place where you can retreat a damaged fleet or capital ship to be repaired.
I usually don't use turrets. The reason is that their range is poor and they are too easy to go around or just kill with long range units. They're not worth their heavy price. I use them to defend repair bays and other key structures; on their own they are practically worthless.
What do you think of the idea that a good offense is the best defense in Sins?
Couldn't be more true. While you occasionally get a random map with some very tight chokes, most of the time it's not possible to create an adequate defense on all your borderline planets, so without a good offensive to keep the enemy's main fleet pinned down you're going to get outflanked and annihilated.
If you have different strategies for single-player against AI and multi-player against humans, please state them!
Oh definitely! The AI has a bad habit of running head-first into your defenses. While in Entrenchment it finally learned to move its fragile siege frigates around your planet to a defenseless angle, it still rushes into tightly packed static defense rather than staying back and pounding them from afar. Because of this, against a player you need to spend more frugally and rely on your fleet more for defense. This also applies to starbases. You can pack a starbase with attack and defense upgrades against an AI and it will run straight into its lethal gunfire, while a player will sit back and never give it the chance to fire a shot.