Most onboard graphics today can handle Aero, I've used Aero with an onboard graphics ATI el-cheapo graphics chip that's more than 3 years old and it ran smoothly.
I had a 7400 with 384MB RAM and it ran Aero on full without any hitches at all. Resolution was 1280x800. So pretty much anything non-onboard will run it.