Just going through the Canon site ( I have a Canon PowerShot and my brother has a 400D), and I came across a camera that'd leave even a good CCD setup for dead (once it was modded). A Canon EOS 1Ds markIII.
21.1 megapixels!!!!!!
Only one problem...it costs $12,000.
Although, if I had the money it'd definitely be on my list of purchases