Do we have to go over this again? Steam supports making backups that don't require an internet connection. You can play all your games offline even if Valve decides to go ape shit.

The only way you depend on Valve is for internet games. Those by definition make you dependent on the servers, even without DRM.

Single player or LAN games are not a problem at all.