You want the Goldberg Emulator which is basically a replacement for the steam_api DLL that lets you play those games offline.

Mind you, not all games using Steam DLL will work with it, but many if not most will by just replacing the game’s steam_api DLL with the one from the emulator.