MooVid(Action) uses HAM8 to display movies on an AGA machine. Although it's slow on an 030 (4-8fps) @ 320x200 it can manage up to 15fps on an 060. It is of course doing a lot more than simply drawing the HAM8 screens though so I'd imagine a game could do it quite a bit faster.
I'm still trying to see if I can get a HAM8 screen working in my PC VGA port (eg if it's fast enough)....watch this space
Apparently an 060 can build (C2P) a low-res HAM screen faster than the chipram can accept it