The following games do not require Xbox Live to unlock the content.

Toejam And Earl (Adds all of the characters from the game to your Xbox without Xbox Live.)
MX Superfly
NFL Fever

The only thing you must have is the actual game to play these files. You must have a saved game file from the game on your hard drive.