I am a big fan of my
Micro-Nikkor 105mm AI-S lens. It is full manual: aperture ring and very fine-tuned focus ring. The focal breathing is something to be aware of, but I tend to crop-compose my shots anyway so it tends not to be a problem. I picked it up for about $200 used from a local store.
My only complaint with the lens is that it only gets to 1:2 ratio without the PN-11 extension tube, and I haven't found the extension tube at a good price. That said, I've only really "needed" the 1:1 ratio for very tiny bugs which doesn't happen very often. Heck, considering your D5200 has even more
megapickles than my D7000, cropping the image to get closer is even less of a problem for you!
As far as tripod and VR go, I guess it depends who you ask. I do nearly all of my macro shooting hand held. That partially comes from me having a lousy tripod and not having convenient things like a focus rail, but also because I prefer shooting bugs and those guys don't typically hold still for very long. VR is definitely very useful for hand holding macro shots at low shutter speed. It may be because I don't have VR, but I simply don't do that. Shooting by hand with a paper-thin depth of field pretty much demands a high shutter speed and plenty of light since even the slightest movement from either you or the subject can ruin the shot. I typically don't shoot at less than 1/200, and at that speed VR isn't as useful for me.
Would I like the newer 105mm AF-S VR? Absolutely! Actually, had I the money I'd probably go with the Sigma 150mm Macro OS, but both are out of my price range. I've enjoyed my fully manual lens and I've learned a great deal more about the Big Three (shutter speed, aperture, ISO) because of it being fully manual.