I have the 300D and Kit Lens, even though its a kit lens, the images produced with its 6.30 MP sensor, and cheap wide angle lens, are all SHARP.
its a entry level DSLR camera, and its cheap. So it doesnt mean to say a Expensive 'Canon L Lense' is needed for sharp images, surely it would have better results, but the kit lens does the same job, and is sharp alot of the time.
But if you had the money, and the sky is the limit, i'd go for the Canon 1Ds Mark II, with a sweet Canon L Lense.
if you want to view pictures produced by certain cameras visit
www.photosig.com -> photos -> filter by camera type -> select the camera model you want
Heres some pictures i've took with the 300d
http://www.base51.com/images/123_2360-1.jpg
http://www.base51.com/images/123_2362.jpg
Before you buy a camera, be sure you read alot of reviews and see if anyone has experienced any problems with them.