I do alot of food and travel-type photography, and ended up buying the Canon 300d Digital Rebel last year after my 4-year love affair with my Nikon Coolpix 990 ended when I finally broke it. I loved the macro feature on the Coolpix (the little flower icon).
A couple tips when looking at digital cameras....
Be realistic about what size camera you are willing to carry around:
I love the flexibility of the new Canon (I can change lenses) and the file sizes are great for when I choose to make prints, but I don't enjoy the shape of the SLR -- it can be a pain to carry around. I've learned that if you don't want to take your camera anywhere because it is too big, you don't end up with great pictures. So, be realistic. There are great pocket sized cameras out there with amazing optics, reasonable pricing, and high mega-pixels for when you want to make prints for friends.
Trade-up over time:
Make a list of the features you know you want: size, shape, weight, zoom, MP, media type, etc -- and go for that. Don't go over-kill thinking you need a ton of extra features - or a physically big camera (SLR) to get great results. Some of my favorite shots ever have come from simple point and shoots. If you grow out of your camera over time, and are looking for different features, you can always trade up.
So, on the consumer end, Ive been happy with the Coolpix series (and they have some great picket sized cameras), and on the 'pro-sumer' level the quality of the pics from the Rebel have been great if you don't mind dragging a full size SLR around.
Some shots taken with the new Canon Digital Rebel:


And here is a
small gallery of non-food shots, all taken with the Canon from Sri Lanka last month.