Kipper2k has said in a few threads that he wants one for the CD32. I don't know if the team is thinking of doing one - the CD32 would probably be the smallest audience - but if anyone can convince the team to make one, I wouldn't think anyone could be a more effective advocate than him. A couple of times he's sounded pretty adamant.
He said it wouldn't be that difficult since the expansion connector on the CD32 and the trapdoor expansion on the 1200 are essentially the same other than the physical connector.
Personally I think a CD32 with a Vampire accelerator would be just about ideal. Sure it doesn't have a keyboard built in but connecting one is easy. It's fairly small so easily portable, already has a CD drive built in, AGA with S-video if you didn't want to use RTG for some reason and I think it has the greatest free volume where the Vampire would be so cooling should be less of an issue.
What would be really cool would be if they could do something like the Paravision SX-1 that plugged into the expansion connector and let you plug the FMV cartridge into the SX-1. I know it's only Mpeg1 / VCD so it wouldn't have the video quality of Riva say but it would offload the processing from the Vampire. Maybe? I don't know enough to know if it could work that way but I can't help but think that that would be super exciting
As far as I know, you can plug an SX1 and an FMV cartridge in at the same time.
Now find an FMV cartridge.
And adding a Vampire to the CD32 would be no mean feat since the '020 in the CD32 is surface mounted.
The expansion slot might be one way to connect an accelerator, but the SX32 is the only one I know of that does that right now.
Personally, I love my CD32 with SX1, and would welcome something that would speed it up.
With a fast enough cpu, you might not need a full motion video board.