And I'm wondering what are the essential mods for this game? Things like graphics, player homes, quests, etc.

An excellent place to start is Vargr's list, a copy of which you can find in the link below. It is post #43. There are some other mod recommendations in the thread as well.

http://www.gamesas.com/topic/1472297-basic-vanilla-modding-recommendations/