I loved my Opalvision card, and used Opalpaint (plus a few Opalvision tools from Aminet) for quite a while. It's not the best paint program out there, but results are really more a question of talent than the program.
I'd probably still use it if I hadn't upgraded to a RTG card, Brilliance, and ImageFX.