Actually, quite a few do:
http://www.powerupgaming.ca/Which-Nintendo-64-Games-Require-a-Memory-Card_b_6.html#.VZYQ4UZ0f5V
And I just read that models of the memory card actually require batteries, and some have EEPROM. Is this true? If so, anybody know how to tell which cards have batteries...