And then my answer is still good lol
Some Single Player games need a constant connection for authentication, I believe only some Ubisoft games, those will probably have an issue in Offline mode with Steam. Then again I don't have any experience with that.
All other Single Player games (and I mean anything with a SP mode, even if it has MP) should work. All you need to do though, is unplug and find out.