More detail usually means a performance hit, but there are three different levels of quality to choose from if you have issues running the biggest textures. Everything from roads, trees, buildings, vehicles, and other objects have been retextured (sky, water, characters, and weapons are untouched).
There's a morbid sort of beauty in a decaying landscape, and the NMCS Texture Pack makes New Vegas even more bleakly attractive.