Thanks for the input guys, it has helped a lot in my decision making process. I've been poking around on the sites and came cross this one (and I think someone here mentioned it too):
No Cropping Zone
Now THAT is what I aspire to!
I like his whole "philosophy" on macro shooting. He uses the MPE, handheld...but the trick is having that $800 flash unit...ouch...but some seriously good results IMHO. Still, I like his methods and probably the direction I'll end up going. This method appeals to me because I can just go out, walk around and start shooting whatever grabs my attention, quickly and easily without toting around a tripod and other equipment and then taking the time to set it up. Using lots of light to crank up the shutter speed to "freeze" motion is a nice idea and the key to shooting hand held in this case I think. His results speak for themselves, it works, without question.
I think I'm leaning toward the new D3200 also because as mentioned, more pixels which gives more cropping wiggle room. I admit, the whole "pixel count" thing grabs my attention. I've read many posts on the subject and the ensuing arguments about how pixel count isn't important and some think it is merely a marketing ploy for the "uneducated", but I know enough to know that having the extra pixels gives you more options and options are always good. Certainly it can't or won't makeup for poor technique, I get that.
I'll probably end up with one of the Tamron or Sigma, or maybe even the Canon 100mm macro initially and as mentioned, throw on a magnification lens on the front to start with (the combo gives a much broader capability for shooting in general). I do want that MPE at some point though!