Having a hard time finding the right camera for Macro shots?

Any canon camera would be a match for it. I mean, depending on the lens you buy will determined how much better your pictures will turn out. If I were you, and I could afford a 40D I would go with that. I currently have the XSi and it works amazing for me and I love it, but I'd upgrade if I could.