Among the reasons I didn't have many of the problems people have mentioned, in Skyrim:
1) To me, "unique" doesn't have to mean "all powerful". This is also why I really have a hard time understanding the "I wait on quests until I've ground my level to 30, so I can get The Best Versions" Oblivion players.... I really don't care that my Shield of Chorral might not be the best version, or might be replaced later by something else - it was still a "unique" reward, and it was still (depending on class, of course) a useful item for some range of levels.
Also, "unique" can be a unique power, a unique model, a unique skin..... those are all valid "uniqueness" for me. Just started a mage-ish character this week - treked over to Froki's Shack to pick up that unique Light Armor/mage enchanted circlet. Great piece of gear.
Then again, when I explore I'm not looking for special loot in remote or hidden locations so much as I'm looking for the locations themselves. Of course, I'm the type of guy who will spend literally hours trying to scale remote cliffs in order to see if one of the developers decided to leave a little surprise up there for those willing to attempt the climb, so what I find isn't as important as the fact I made it in the first place.