Nope, you can start steam in offline mode, although it is a lot quicker if you unplug your internet first as it still keeps trying anyway if it detects one.
Strangly spore for me only works when I'm disconnected form the internet... <Insert copy protection quip here>