This loader worked brilliantly for audiosurf, but it can't run Civ4 Beyond the Sword. I put the files into "common\sid meier's civilization iv beyond the sword\Beyond the Sword", along with original steam.dll, steamclient.dll, tier0_s.dll and vstdlib_s.dll. I created a steam_appid.txt containing "8800" (correct appid), and set ProcName=Civ4BeyondSword.exe, SteamClientDll=steamclient.dll.
However, when I run revLoader.exe, I get an error box titled "Steam Error", that just says "Application load error P:0000065434".
EDIT: Scratch that, audiosurf doesn't really work, it just waits until you try and start a new game to complain.