Tomer, it is kind of a sad place, at least how I experienced it. I was never there during a heyday.
The idea that this is a lost civilization, that the D'ni, for the most part, are gone--that's sad to me. And some of the music is very haunting, beautiful, but melancholy.
And on a more personal note, the last time I visited Uru, my sister and I did it together. She was my gaming partner for years, and we shared all our adventures. She passed away 4 months ago, in December. It's only been recently that I've started playing games again. Very tough without her. I'm not sure I could handle the D'ni caverns.
"Dragons were never gone. They were just invisible and very, very quiet." ~ M'aiq the Liar (Skyrim)