In MMORPG terms the collect 30 or so X from monster Y when there are about a dozen people doing it and the drop rates are low are worst . Favourite in MMORPGs... any Instance.
Out of MMOs I only really play JRPGs and they don't really have Quests. I guess I quite liked the Tranquility Lane quest in Fallout 3.