I found a site with a list of games that support the ram cart but I don't want to post a link because the site made my anti-virus program go off with warnings. I'll post the info here for future reference however:
Sega Saturn Games That Use 1MB/4MB RAM Cart
For those of you that are interested, here are the Sega Saturn games that support my 1MB/4MB RAM carts. Most of these games require the RAM carts in order to play them.
The ones that have (OPTIONAL) do not require the cart, but will have better performance with the cart
4MB RAM:
Dungeons & Dragons Collection
Final Fight Revenge
Friends: Seishun no Kagayaki
Marvel Super Heroes
Marvel Super Heroes vs Street Fighter
Noёl 3
Noёl 3 Limited Editon
Pocket Fighter (OPTIONAL)
Street Fighter Zero 3
Super Real Mahjong P7
Vampire Savior
X-Men vs. Street Fighter
Some Various Emulators
1MB RAM:
Astra Superstars
Cotton 2 (OPTIONAL)
Cyberbots (OPTIONAL)
Fatal Fury 3
Fighter’s History Dynamite
Friends: Seishun no Kagayaki
Groove On Fight
King of Fighters ’96
King of Fighters ’97
King of Fighters, The: Best Collection
KOF Double Pack: King of Fighters ’95 & ’96
Metal Slug
Noёl 3 Limited Editon
Noёl 3
Ragnagard
Real Bout Fatal Fury
Real Bout Fatal Fury Special
Real Bout Garou Densetsu Best Collection
Real Bout Garou Densetsu Special
Samuari Showdown IV
Samurai Showdown III
Samurai Spirits Best Collection
Samurai Spirits: Amakusa Kourin
Samurai Spirits: Zankurou Musouken
Super Real Mahjong P7
Super Real Mahjong P7 P’s Club Limited Edition
Waku Waku 7
So Marvel Super Heroes is the list. I'll have to nab a Ram Cart at some point; I looked on eBay and the few I saw were pretty pricey however. I think the game uses a three punch three kick setup so the Saturn controller is probably great to use for it - in theory. Maybe the d-pad won't destroy my thumb like the one on the PS controller does when playing Street Fighter-like fighters. (I have sensitive thumbs and can't seem to work up game-related calluses anymore.)
Still, despite the fact it isn't listed as optional I think the RAM cart is optional with MSH.