Yes, the 660/840 DSP did also see use for GeoPort.
In theory, the DSP was usable generally, but to my knowledge, no other programs ever used it. (Edit: Whoops, BigD already mentioned that, and that there's samples and everything.)
Just by way of fun historical sidenote:
W/re IIvx and Performa speed, they were roughly half the speed of a IIci when they were new, owing mostly to the bus. MacWorld did a review of the Performa 600 in late 1992 and it got a fairly good result, they were happy with it even though it was slower than the IIci, mostly because they saw it as a fairly good value for money and a reasonably good way for Apple to expand the potential Mac user base.
Plus, in 1992, the Quadra 700 and 900 had started to exist and if you needed ultimate performance in that moment, you could go buy one of those.
I had a Performa 600 as a kid and it was thoroughly "fine" -- basically just as beachycove said. It ran 7.1 fine, I think I played a little bit of SimCity 2000 on it, but this was in the early 2000s and so I also had an 840av, iMac/233 and a Performa 578 (which I think had been upped to a full 040) all laying around and so that machine didn't really hold a special functional place at the time, especially without networking and without, at the time, a whole lot of need for a super-basic productivity machine.
The 600 has the distinction versus the IIci of, of course, having its own VRAM, and if you have the VRAM add-on it'll do 640x480 at thousands of colors, which, for what I imagine Apple thought the machine would be doing at the time (CD-ROM edutainment, Bookshelf/Encarta types of stuff, things that already ran fine on the original LC, basically) would be a benefit over most of the other Macs at the time.
Anyway, the other thing is basically "when are those games from?" and "can you find a system a little closer to that era" and a 660 would be a great system a bit closer to that era, and by my recollections, 660s accelerate to faster '040 speeds fine if you wanted to put a faster '040 in and chip it, although the 650 is slightly more flexible on that front, so choosing a Quadra is getting onto another plane of existence from any '030 Mac and then choosing among the Quadras and what acceleration/add-ons you want is mostly a matter of choosing what things are your priority within that realm.