Basically, you'll like your non macro shots you take with that Nikon you listed. They will most likely be very sharp when compared to zoom lenses, especially cheaper ones like you listed in your first post.
However, you're stuck at that focal length... so your mileage you get out of the lens will vary based off how willing you are to use your feet to compose the shot rather than use the zoom in and out ring to compose...
If you can compose right with a 105mm lens, you'll really like the pictures, fixed or prime lenses are known for being superior to zooms in picture quality.