Thanks for all of the suggestions. This will be a great help. I have been looking at some games such as adventure games in the vein of Myst, Zelda, & some even suggested Riven since the sequel to Myst. So I guess I will be visiting GameSpot soon.
Thanks again for your help!!
Elder Scrolls IV Oblivion! While it isn't a traditional adventure game it gives you the freedom to go out and explore as much as you like. I recently got sucked back into playing the game again and at level 16 I've only done the first few main quest levels. The other 8 hours we're spent solely on exploration, dungeon crawling, and practicing alchemy.