A lot of automatic camera have a closeup mode (usually the flower icon). Perhaps you just need to set your camera to that mode.
I have a Kodak DC5000 Digital camera and really like it. It does eat batteries, but I bought a gazillion pack at costco, so they don't cost very much. The camera was around $300 (a while ago) and I bought a 128mb compact flash card for it from costco for about $60 (They're $55 now). With the 128mb card I can take about 206 pictures on highest resolution, best mode; 581 pictures on standard resolution, best mode; and 1579 on standard resolution, good mode. If the card gets full, I can download them to the computer, write them to a CD or whatever, and just take more. I bought it also because I was tired of buying film, paying for processing, waiting for processing, having to keep negatives and not scratch them (which will still deteriorate over time). The only thing I don't like about my camera is that it only saves in JPG mode. I kind of wish it would save as TIF for lossless re-saves, but I can always save it as a TIF from the original and then have lossless re-saves.
Another camera I like that came out recently is the Nikon Coolpix 5000 ($1000)