The 'most amazing' camera is the 5DMkII. Great still images. Great video. Uses great Canon primes, and via adapters, can use just about anything else by other manufacturers. What more could you need?
But, the "coolest" camera may be something else. Maybe the Nikon F6 if we're talking only about "currently available," as in "available new."