It depends on the mood of the level you're playing. Obviously, when a Single Player pack/level uses scenery to match the storyline, it can be beautiful depending on how you use it. If you use very realistic tilesets for a single MP level, it can distract you too much. Like "Oh wow this wall is beaut-" You Got Roasted.

Catch my drift?