I was under impression the biggest cards have up to 1-2 MB RAM, 128 MB flash and relatively fast 32-bit MCUs.

And that was a few years ago.

Edit: Found a PDF from 2006 that talks about even higher spec SIM cards: http://www.spansion.com/products/documents/hd_sim_whitepaper...