Consoles really aren't the best gaming platforms to have if you're a fan of graphic or point and click adventures. Broken Sword is really the only game of it's type that I can recall being released on this generation of consoles. I think the latest Myst game has been released on Xbox over in the States, but apparently the port is pretty weak.
A really good adventure game that I've played recently (available for PS2, Xbox and GC) is "Beyond Good & Evil" from UbiSoft. It was released back in 2003 so you can get it really cheap. It's not point and click, it's more like a Zelda game and there's fighting in it. The fights aren't very prominent though and they're very easy and don't really require "twitch" gaming skills. The crux of the game is really about exploring the environment, solving puzzles (which sometimes involves stealth) and taking pictures. It's a really fun game with some memorable characters in it and if you're willing to give it a try I think you'll enjoy it quite a bit.