A CSPPC/060 when fully loaded with the CVPPC was the cats meow.
I can only speak here from my practical use here. Keep in mind I sold off my CSPPC/060 a few years ago. Since the CSPPC and the Mark 3 sahre the same scsi here are my experiences.
It's scsi speed outclassed my expen$ive stock Mac beige G3, and flyer drives of the time. Was good for processing flyer clips such as reverse clip, your basic timeline, renderFX, and audio thunder. Running the flyer and toaster software from the SCSI drive meant faster load times. I remember I was able to do a couple of things newtek said wouldn't work in regards to using HAM8 transitions, framestores, Video clips off the audio drive, and clips very close in timing to each other, wheras an 040 amiga with the IDE hard drive would get a playback error using lots of framestores and transitions.
Don't know how much ofthis is attributed to the CS060 but I figure 128 megs ram, scsi 3 18 gig hd, and an 060 couldn't hurt.