I recently got to explore Nik Color Efex Pro 3. WOW !!
This is a fun piece of software and the effects are great. It worked great with photoshop CS4 and with Apple Aperture. It is also available for Capture NX2.
I will write up a full review soon, but here are a couple of examples of what can be done with a click in Color Efex Pro 3.