The Gamecube is a hotspot for those sort of games in my experience, if stuff like Legend of Zelda falls into that category. Some nice adventure games with intriguing puzzles I remember on that...