Aperture is very attractive to me, although I've been using a combination of Photoshop CS (for raw conversion and touch-up) and Google Picasa (for bulk adjustments, management, previewing) that gets me 99% of the way there, and doesn't require exotic hardware support. I'm very curious whether Nikon will add extra juice to the next rev of Photoshop to compete.
The Nikon D200, at least what we've seen of it, is very cool but I'm not entirely certain if I want it. The decision for me comes down to (a) how good its autofocus system is and (b) how good its high-ISO performance is. The extra resolution is largely irrelevant. We know it has an 11-segment autofocus system, but we have no idea how well it works in low light or whether it tracks action as well as the D2h/D2x autofocus. Likewise, we know absolutely nothing yet about the high-ISO performance of the sensor. So, until the proper DPReview comes out, I'll be holding back on that particular decision.