Christian Buil has compared the 40D with to 50D at
http://www.astrosurf.com/buil/50d/test.htm
This gives some idea about the effect of the smaller pixels on overall performance.
Another review comparing canon to Nikon cameras is at
http://www.astrosurf.com/buil/nikon_test/test.htm