My boyfriend and I (both advance divers) stayed at the Lodge Kura Hulanda last September and had a very lovely time. We were very happy with the lodge and its location, as well as the dive operator. I think would be perfect for you and your wife if you're looking for a quiet, relaxing location that's away from everything. I think Damelfish's post describes the dive shop and resort perfectly. We had an oceanview room that was spacious and exceeded our expectations, particularly the very large outdoor patio and, in addition, private walkout circular lounge/sunning area. The hotel beach isn't large but wasn't crowded in September so it felt spacious enough.
We bought a five-day dive package with Ocean Encounters West when we booked our hotel and did morning boat dives. OEW was a good dive shop, although I wish they had a bigger gear storage/suiting up area. (I've been spoiled by CoCo View Resort's (Roatan) gear area! Lodge Kura Hulanda is a more comfortable/upscale resort, though.) We also dove the house reef, which is really wonderful. I think some of our best diving in Curacao was at that reef; lots of amazing coral, ton of moray eels, crabs, spanish lobster, shrimp, parrotfish, etc.
We did rent a car for the week as we wanted to see the island and eat outside of the resort a few times to supplement our 4 or 5-day meal package. (There was some confusion on the part of hotel staff when sorting out our meal package when we arrived (a common problem described in other postings) but it got sorted out.) We drove into town for dinner two or three times, ventured out for lunch a couple of times (great lunch venue down the road, better than Jaanchies), drove to Boca Tabla (worth it if you have the time), and went sightseeing in Willemstad (Kura Hulanda Museum is great). It is a bit of a drive into town, but it's a straight shot and a pleasant drive across the island.
I highly recommend the Lodge. It's a great place for divers given the good dive shop and great house reef, as well as non-divers who want some r&r in a very comfortable and beautiful setting.