If you plan on keeping it simple with the '030, a Spectrum 24/28 is a nice little card. Passthrough for Amber, Z3, snappy performance, and clean picture quality. Piccolo SD64 would be a better performer, but they are somewhat rare. I'd steer clear of the Cybervision 64/3D, no passthrough, so you'd need two monitors or some other extra BS.
Maybe the Spectrum I saw a long time ago had an early driver or something because I thought it was slow in a 3000. The Zorro III mode didn't seem to add much if any performance either. The older manufactured ones had reliability problems of some part blowing up on the card. The passthrough is nice and the used price is usually good. The Cybervision 64/3D has much better 2D performance and can usually be overclocked substantially for better performance. The 3D performance is poor but way better than none. Lack of passthrough is a pain. I have a monitor with 2 inputs and an input switch on the front which is fine after getting used to it.
Picasso IV is hands down the best one, but it's expensive, and overkill for an '030 IMHO. It has its own scandoubler, but it can't be easily calibrated for perfect game scrolling. Some argue that the Cybervision 64 (non-3D) is best suited - performance just a bit below the Picasso IV, and it has a passthrough for Amber. That's what I run in mine.
I agree. The original Cybervision 64 is probably the best Zorro III Amiga 3000 card for the price and very close to the Picasso IV in a 3000.