Matt-
I'm really terrible at describing this, but I'll try my best. Right now I have a 28-200mm zoom. When I'm at 28mm, the closest thing I can focus on is about a meter and a half away from me - now, what I'd like is for the image to be exactly the same as it looks through the 28mm lens, but to be able to focus on something half a meter away, say. I'm already able to focus very close, but only when I zoom to the 200mm option, and this is not what I want. Maybe I shouldn't have used the term Macro, (like I said, I'm terrible at this!)... but do you think there's any lens where this kind of thing is possible?
I think that discussing this is going to be a bit of a challenge

.
My problem with your description is that if you are a half a meter away, the image is going to be quite a bit different, because you are closer. At the same focal length, you will see a fair bit less of the scene, because you are closer.
Now half a meter away at 28mm is very low magnification - not nearly macro at all.
I don't use zooms for most of my cameras, so I don't own anything equivalent to experiment with.
My 35mm fixed focal lens focuses to about 10 cm.
My 24mm fixed focal lens focuses to about 8 cm.
It sounds to me like your zoom focuses most closely at the long end. That isn't universal - many such lenses focus most closely at the short end.
For us to help you, it would help to find out what you are most interested in:
1) being able to focus on a particular space; or
2) being able to shoot at a particular distance.
Usually, those who are looking for the second of the two choices are seeking a particular near to far perspective, or are trying to deal with some lighting challenges.