Just about any camera out there will work for you. It all depends on how much money you want to invest in lenses. As someone mentioned, it is ALL in the lenses! If you think you're gonna end up investing in a bunch of different lenses, start off with the body only and get lenses that you need.
The 105mm macro lens I want is almost a $1000! And it's only for taking macro shots! You will pay the big bucks for quality lenses. Here's a link to the macro lens I wanna get.
A macro lens is a specific type of lens that allows you to take really close up pictures. Don't mistake this for a zoom lens. The packages you can buy will be fine for taking everyday pictures and photos will turn out just fine. You'll need to learn how to use them properly, though. A lot of people will discover that those little point and shoot cameras will take "better" photos than an SLR. That's mainly cause you have to fiddle with the SLR's a little more but you have greater control and potential with them. The point and shoot cameras have all kinds of color enhancement/sharpness built in so you get consistent good photos with little adjustment. These are great for the size.
You have to learn how to take good pictures with an SLR. The more you learn how to manually take photos, the better the photos will turn out. And using flash in itself requires a bit of study. There are tons of photography books for specific purposes. Landscape, people, architecture, close-ups(macro), flash, action, and so on.
All really depends on how involved you wanna get. If you just wanna snap a few pictures here and there OR take quality shots like you see in the magazines.