JSt0rm
Lifer
The point is that if your connection goes down you should still be able to play the SP games that you own. That Steam doesn't allow this is a gaping hole in their system in my view.
Did you try disabling your nic like the poster above suggested? I'm just wondering incase I'm in this situation.