Photokina is close, so better wait until its over before getting camera recommendations. Even if you get an older camera afterwards, very likely they will be much cheaper, if you buy them used.
Also, every camera is a compromise. Always.
Even if you get the best consumer camera right now (which proably right now is the Nikon D800), get the best glass for it, there will still be other cameras that can do things your camera cannot.
The market for high quality consumer cameras looks like this right now:
- Canon and Nikon are the current market leaders. If you want a large number of available lenses and a huge second hand market, these are the two candidates to choose from. They both have their advantages and disadvantages. See for example
Nikon vs. Canon for a discussion about the two systems.
- Pentax is an old combattant on this field. A recent study about user satisfaction said Pentax users are the happiest. The lead before Canon and Nikon was only by a hair though.
- Sony is the new guy. Very flashy cameras that work well in magazine tests. Unfortunately photography is art, and what really matters in a camera is hard to display in numbers.
- Leica is the old german company. They produce very expensive manual focus cameras, exclusively with very high quality and very expensive prime lenses. Their current model is the M9 and it is expected that the M10 gets first shown at the Photokina.
- Fujitsu is another old camera company. After they had little success with DSLRs compatible to Nikons F lens mount, they recently started their X system, which is some kind of smaller Leica with combined optical and electronic viewfinder, a somewhat smaller fotosensor (socalled APS-C size), but an autofocus. Personally I think the X system is an absolutely awesome idea, but the system is too young and has too many problems in the details.
- There are also smaller players like Panasonic who cant really compete in terms of quality. Panasonic DSLRs reportedly do great video though.
- Sigma should also be mentioned. They do cameras with the Foveon X3 fotosensor. Sadly these sensors have poor low light performance and also some problems with colors. Additionally, the cameras are in general horribly expensive and their features are limited. However, thanks to the Foveon design, Sigma cameras produce "real" pixels, i.e. all three colors are measured in every pixel of the image. So while the newest generation of Sigma cameras "only" have 16 Megapixels, that is truely the resolution you will get from the camera. Very interesting for example is the new
DP2 Merill which apparently is quite affordable.
Ratio "good shots" vs "bad shots": Especially with digital, really nobody cares how many bad shots you take. Just dont publish those.
The very famous landscape photographer Ansel Adams once stated that one good picture per month is a good ratio.