it's not really the camera that makes the shot good, its the lens that you use with it
stock lens doesnt really do much
nikons are more vivid...
this was taken by the D90
this was the canon rebel xsi. you can see the water captured nicely while flowing
i personally liked the canon more than a nikon. right now i use a panasonic gf2 and it's not bad at all for a small cam