Hi,
I think part of the reason why the datasets look like they do is because you load them into SDE. In SDE you can only have a managed raster catalog. Unmanaged raster catalogs are not supported. As such you load your data into SDE, and part of the loading creates statistics. This is why certain tiles display differently. You can try to load an unmanaged raster catalog in a file geodatabase or personal geodatabase to see if you get the same results.
If you have version 10 you could also try a mosaic dataset (like an unmanaged raster catalog in SDE).
Let me know if this helps.
Robert