"640 kB ought to be enough for anyone" comes to mind here...
Quite seriously though, it is always possible for someone to write an application/game that does something useful with more memory. So as long as technology scaling continues, there will never be an amount that is high enough for all applications to be unconstrained by it. At the same time, GPU memory is somewhat virtualized (and becoming more so), so a game/application with a working set that pushes the limits or even exceeds the DRAM size is more likely to slow down than to fail to run.
So I would suggest completely forgetting about the specific DRAM size when shopping for a GPU, and buying a card based on empirical value (performance, efficiency, features, etc) per $.