All I can say as a moderator is this:

Whenever I unexpectedly receive a gracious e-mail or private message thanking me for my help, or when a fellow FlyerTalk member decides to post a genuinely appreciative milepost in a public forum praising how I have helped them, it makes the job truly worthwhile, outranking any negative aspect of being a moderator by far.