Well I'm not expecting a miracle of it pushing performance out of a voodoo 3 3000..
What about some of the recent intel onboard graphics cards for example? could I do most 2D animations in that?
Yes more than likely, you'll just need to keep an eye on the handle count if it is a long-running application. On one onboard intel (945?) we were losing dozens of handles a second when doing opacity, another box with the same hardware only lost one or two a second - and they were both identical new builds.
I'd try and get a Tier 2 card though if you want to be entirely safe