sorry for taking a while. As Gordon said: There sure is SW that makes a standard pic look curved like a real fisheye shot, but two things can never be simulated:
1. the wider field of view that e.g. the 10.5mm Nikkor fisheye gives (it's almost 180 degrees diagonally!)
2. the shift in perspective, when you go really close to a subject and the background falls away significantly, like a small flower in the foreground in perspective to the large mountain behind. See one of my favourite fisheye photos over here: http://www.flickr.com/photos/wynandvanp ... 264170988/
Some of my own fisheye shots so far can be found on flickr here: http://www.flickr.com/photos/38912116@N00/tags/fisheye/
The trick is, that fisheye shots can be straightened out by SW so as to look like a ultra wide angle lense which is a very interesting combination: you can capture the wide angle and the specific perspective and at the same time make a perfectly normal looking picture out of it...
But to be honest, normally a lens starting at 17/18mm captures quite a bit...
As to your macro question:
As a Nikon fan - if you want to buy the best: grab the AF-S VR 105mm 2.8G IF-ED! I own one, and its VR image stab is most important in macro shots, as the large magnification also magnifies your every shake and wobble (unless you carry a tripod with you all the time). As my D80 also allows for continuous focussing, this combination a dreamteam when it comes to macro shots out in the wild.
Follow the articles at http://www.cameralabs.com/forum/viewforum.php?f=16
Thomas (beware: Nikon-fanboy and moderator!) My Lens Reviews
, My Pictures
, My Photography Blog