For what it's apparently designed to do, it's absolutely brilliant. Deadly sharp from say f4 to f8 in regular tele range (see e.g. the almost off-the-scale MTF50 test
here) excellent macro capabilities (maybe a bit short of the 200/4 but you'd have to be really pushing it to see a difference), wonderful colour and contrast, very pretty out of focus areas, fairly resistant to flare and ghosting (and with a huge but very effective hood for zero flare)
As far as I can work out, it was designed as the perfect one-lens solution for a walk in the woods and similar kinds of short-tele nature/macro photography. The VR feature doesn't work at all for 1:1 macro, but it's not supposed to. If you stick it on a tripod and use MLU it's going to work just fine as a full-on macro lens. What the VR is there for is to support more general usage sans tripod, including moderate closeup work like chasing butterflies or taking flower photos someplace where a tripod would be inconvenient. I'm also told it works superbly with the Nikon macro flash R1C1 etc. Framing does change a bit as you focus, due to the IF design (I think) which is the one real fault I've found using it on a tripod and the place where a 70-180 micro (if you can find one) or one of the older micro-nikkors or adding a focussing rail would probably work rather better. It's also a G lens, so it's useless with Nikon extension tubes.
For sheer usability, versatility and clinical accuracy in the moderate tele range though, the 105 VR is very hard to beat. I find it works very well as a 2-lens general use kit with the 17-55, or as part of a three lens kit e.g. add say a 85/1.4 for shallow DoF or a 180/2.8 or maybe a 300/4 if you need extra reach
Having said that, for weddings, I'd go for the 105/2 DC or 135/2 DC. (Ffordes have a mint 105/2 DC going for £499 right now) The 105 VR is not what I'd call a 'romantic' lens. It's more suited to naturalists and forensic pathologists than wedding photographers I suspect. For 'romantic', I'd favour one of the DC lenses, or if you're very skilled the 85/1.4 (similar issues when stopped down, but you can mask them with clever DoF tricks). The extraordinary detail rendition and micro-contrast of the 105 VR will show every blotch and vein with perfect accuracy, the 'portrait' nikkors, if used artfully, will make them vanish.