Good article, I enjoyed the read and it was impressive what developers were able to accomplish with such limitations.
Here are the games from the list that I own:
Warlocked
Cannon Fodder
Donkey Kong Country (GBC)
Mario Tennis
Perfect Dark
Legend of Zelda: Oracle games
For all of these games you could really tell they were pushing the capabilities of the machine, and I can remember all of them for making me incredibly impressed with what I was playing. Whether it be the FMV (Cannon Fodder, the use of speech and rumble (Perfect Dark) or the sheer scope, scale and detail (Zelda).
I'm not sure that any of the games were massive sellers (Zelda notwithstanding), so I would love to see the games brought to an even larger audience with a re-release on the 3DS' Virtual Console.