Most 3D polygon based games will benefit from speed and that includes games like Zeewolf and Virus/Zarch as well as your typical driving, flight and space simulation games. I don't know if there other examples but Battle Chess performs the AI opponent moves faster.
I'd find it hard to justify the price of the 40Mhz version personally and if low end 3D gaming isn't important to you then if the ACA1221 is available it would serve your purposes well.
I'm new to the Amiga with a 1200 as my first machine. Strictly gaming. I don't mind buying the 55Mhz accelerator, but will it benefit me in any way over the 25 or 40?, ie, is the GUI going to be noticeably more responsive?