That's entirely up to the developer, they're not required to use Steam's DRM, and in fact many games will run happily without Steam running once downloaded.