I mentioned Phantasy Star 4's quests. None of the quests rewrote the book on questing, but they were fun because they had great narratives, subplots, and were manageable in size and scope. They never felt tedious. Even "The Stain in Life" was fun for me, but would be a pointless rip off quest in any other RPG. So, more or less, what made any given quest in Phantasy Star good was that it "made vegetables delectable" to quote a salad dressing's ad slogan.
Here's summaries of the quests: http://www.phantasy-star.net/psiv/jobs.html
In addition, accessing them was pretty easy. I didn't feel like I needed to go out of my way to find them or complete them. When quests and secrets feel like they're there just to sell strategy guides, that bugs me. There also weren't too many or too few of them. I wanted to get 100% completion and 9 times out of 10, I never go for 100%.
So, really, the value in Phantasy Star 4's quests was not in the rewards, but in the intrinsic value (namely the worldbuilding, subplots, and additional character development.) Though the reward was a nice bonus. It's the difference between getting a good paycheck for a job you loathe going to vs. getting a meager paycheck for a job you absolutely love.