The Nikon 105 you are looking at is definitely a fantastic lens for the job. Very sharp, crisp pictures, definitely suited for food, water droplets, etc. The VR version runs about $750, though, and if you weren't looking to spend that much, I'd recommend looking at the Sigma 105/2.8 macro lens. It's not really considered a professional lens, but it still takes very sharp pictures at 1:1 in macro, for half the price of the Nikon glass.
I own the Sigma 105/2.8 myself, and wouldn't hesitate to recommend it. However, if someone offered a straight-up trade for the Nikon 105 (which would never happen), I'd trade in a heartbeat.