The best digital camera that Best Buy® sells is the Canon EOS-1Ds Mark III DSLR, and it accepts CompactFlash, SD, and SDHC memory cards. Over the years Canon has manufacturered hundereds of very high quality lenses that would work perfectly on this camera, but without knowing your specific needs it would be impossible to suggest one. If you want to see this camera you could look here:
http://www.bestbuy.com/site/olspage....
Another camera that has gotten great review lately is the Canon EOS 5D Mark II, and it accepts CompactFlash memory cards. A feature this camera has that the other two cameras listed don't is the ability to record High Definition video. If you want to take a look at this camera you could look here:
http://www.bestbuy.com/site/olspage....
Lastly I would suggest looking at the Nikon D700, which also accepts CompactFlash memory cards. You can see the D700 here:
http://www.bestbuy.com/site/olspage....
These cameras are three of the best cameras currently being made, and you can't really go wrong with any one of them. I would suggest going to a Best Buy® store and trying them out! I hope this helps!