Hey, some really helpful responses & advise here. It's humbling when the real veterans chime in on the new guy's naive questions.
Couple of points I didn't even mention.. DOF was brought up by you smarter guys and I have not even begun to think about how it comes into play. I suppose it would behoove me to take that into consideration. My inclination is to try to achieve priority #1 of getting really close and then start fiddling with DOF issues. In many cases I might not mind razor-thin DOF but in some cases I might like to get a little deeper.
The other thing I didn't say is that I'm not as concerned about higher magnification as I am with priority #1 (see above). I have generally referred to these types of shots as "macro" but you can take that term loosely. I think the more accurate term is close focus. If you glance at a couple of shots I posted in the "post your photos" forum you'll see what I mean. In fact, in a rare moment of clarity, I titled that thread "not quite macro".
To the several of you who are suggesting reverse mount / short focal length / reverse kit lens.. I'm going with you. All I've read seems to suggest that as the method of choice for what I want to do.
Thanks again guys, this forum rocks.