As to the OPs question, budget will be the prime factor determining what is available to choose from.
Don't ignore second hand items – nearly all of my current equipment was bought S/H from 'the bay'
Don't get caught up with megapixel arguments – easy sell for a salesman – 'this one has more so must be better', you need a huge increase in MP to increase the actual image quality since all you are doing is adding a strip of pixels along 2 sides to create the difference between a smaller and a larger pixel number. 8MP is not double the pixels of 4MP, 16MP is double the pixels of 4MP.
Also what size are you going to produce your prints (if at all) a 4×6 image at 150dpi (what most people are happy with) requires 600×900 pixels (0.54MP) or at 300DPI (professional photographer) requires 1200×1800 pixels (2.1MP).
Be wary of large memory cards – how many photos will you lose if it corrupts or is lost? – I use 1GB cards and my camera will store 210 pictures per card (I have 10 cards) – I am happy with that loss rate if a card corrupts or is lost, what are you happy with losing in one hit?
Bridge cameras, as already mentioned are a good 'all in one' solution from macro to telephoto in a portable package, with DSLRs you are buying into a system, the DSLR itself is a consumable item with a steady stream of new models from the vendor, the lenses are where you spend the bulk of your money.
These days for pretty much anything with a relatively stationary subject I use either a small compact P&S or my iPhone, I only bring out the DSLR for difficult lighting conditions, action shots and macro work, or when I really feel like carrying several kilos of equipment around with me – carrying a DSLR with a 50-500mm zoom gets old pretty fast, even carrying my S2 Pro with a 18-200mm lens is still around 1.5Kg in my hand.
There are also many 'lower end' DSLRs available with 'kit' lenses which are much lighter and cheaper (under 1kg in the hand).
JPG vs RAW – I don't have time to post process all my pictures, so I just save as JPG, RAW formats change and may not be supported in the future, you can do pretty much anything to a JPG that you can to a RAW in Photoshop, Gimp, etc anyway.
Edited By Timothy Moores on 06/06/2016 16:03:35