Like Deathcape said, the real limit is the developer's ingenuity. A grand total of three Nintendo 64 games were greater than 40mb in size. Before that, not a single game on ANY Nintendo system was that large. And yet you still had long, epic games, like the Mario platformers, the Final Fantasies, the Zeldas--all the good stuff.
Also, I stopped believing storage size limits were an issue when I found out that they compressed a two-disc Playstation game onto a 64mb N64 cart (Resident Evil 2) with minimal quality loss.







