Personally, I find stuff like this a bit depressing. I mean sure it look very good and all that, but seriously, how the fuck am I supposed to compete with visuals like
http://img530.imageshack.us/img530/6425/00085y.jpg/ as a fellow mapper?
I want to be a level designer, not an environment artist, but I still want my maps to look good. I just neither have a few chinese artists on my payroll, nor the extraordinary talent of a few people out there who can not only make good gameplay but also make it look stunning as well and to top that off, they can do both at a ridiculously fast development pace.