You don't need to go all out for this like a lot of people think.
But, if you want a larger, more feature-filled (assuming) camera, I'd look at Canon Rebels. Otherwise, Kodak Easy Shares have higher mp cameras with really nice features for their price, including a setting specifically for close shots of plants.
I use a Kodak C875. I can get shots at the right angle and in the right lighting that look like they were taken with a macro lens, easy.
Good luck.