MDF "can" look stunning. It can also look craptastic (Yes, Dark Sphere, I'm looking at your tabletop terrain ...).
I guess everyone has their favourites. Personally, I'd "like" a planet(oid)'s worth of HALO terrain ... but no one really makes it ... so in the mean time, Antenocitis does -
IMHO - some of the best pre-coloured
SF MDF around ... e.g.
Spoiler tags added! - BrookM