When you buy a digital SLR you aren't really paying for all of the features. Or rather, you won't use them all. They pack the features in them but no one uses them all. You choose the camera that has the features and quality you need and don't worry about the rest. And the main reason to buy a digital SLR is the sensor quality. They have larger sensors that capture much better quality images. But they will cost you more - a lot more.
If you're not really sure about digital SLRs, I think you should look at a high-end compact camera. I don't know what cameras you've had, but there are point-and-shoots and the then there are compacts that offer almost all the control and features of a digital SLR. They use a smaller sensor so the image quality isn't as good. But that doesn't mean its bad. Use them correctly and you can get wonderful quality. And most important for you - they all have built-in closeup capabilities. You won't have to buy a special lens to do the kind of closeups you're talking about. Nikon, Canon, Olympus, Kodak, Pentax, Fujifilm, Panasonic and Sony all make good compact "superzoom" cameras. They look like small DSLRs but they don't have changeable lenses. I think a camera like that might be your best bet. In no particular order, here are a links to a few of them so you can take a look:
Nikon Coolpix P90
Pentax X70
Olympus SP-590 UZ
Fujifilm FinePix S200EXR
Sony Cybershot H20
And for a more in-depth look at a superzoom compact camera, read our pro review of the Sony Cybershot H50. Personally, I like the look of the Fuji the most. I haven't had a chance to use it. But Fuji's new EXR sensor is supposed to be really good.
I'm sure you'll have more questions. Take a look at those reviews and let us know what you think. Read the Sony H50 pro review because it has a lot of general stuff on the benefits of a superzoom camera.