Hello Mouser,
I purchased a used Retina Z3 about 6 years ago for my A4000. One of the BEST investments I have ever made. But if I had the choice between the Retina and a Cybervision I would take the Cybervision!
As far as driver software? I gave the Retina Emu about 10 seconds on my system. It's CRAP compared to CGX or P96. (Please keep in mind that when it first came out it was adequate. Remember there wasn't much else out there.)
Throughout the years I have bounced between both of them. I personally like CGX for the drag down screens. P96 doesn't allow this. (Not that I really have a need for this feature. It just makes me feel I’m still using a classic Amiga.) P96 is also very good, in fact I like it more than CGX. Something about the interface and the feel of the perfomance. It seems quicker.
Right now I have CGX 4v.0 installed because I can use Lightwave 4.0 with this GREAT patch I found on Aminet that allows me to render on a non Picasso video card. There is no patch for P96.
Bottom line. Unless you have a specific need they both seem to work just fine. I hope this helps!