Spellfire would be a good book to start with, really captures the flavor of the Realms
Seconded on Elaine Cunningham's books, and Salvatore's too.
The Avatar Trilogy (Shadowdale, Tantras, and Waterdeep) would be a good pick-up, as would the Shadow of the Avatar trilogy (Shadows of Doom, Cloak of Shadows, All Shadows Fled) by Ed Greenwood (actually, I would recommend any book by Ed Greenwood, whether it involves the Realms or not). The Avatar Trilogy recounts the main events of the Time of Troubles, when the Gods walked Faerun, and the Shadow of the Avatar trilogy takes place during the same time frame, and involves different main characters.
Who cares if Elminster saves the world and gets to bang 20+ chicks a day? Some guys would be so lucky. And after saving the world from assorted gods, demi-gods, and liches wouldn't you want to unwind with a beautiful wench?