on the PS1 there's Echo Night. Pretty fun game, but the voice acting (which there is a good amount of) is pretty "strange." it is a horror-ish ghosty walking simulator.
Raw Danger on Ps2 is pretty bad in the voice-over department. (Agetec, you magnificent bastards.) I wouldn't say it was necessarily an adventure game, but that's just me.
On ps2 Wreckless: The Yakuza Missions is hilariously bad. So bad. Probably my strongest recommendation for now. It is an arcade driving game.
Perfect Weapon on Ps1 is over dramatic. Pretty funny. Best part of the game however is in his movement, if you bump into anything (and that is a very common occurrence) your character will blat out "no-way." it has to be played to be fully appreciated. It is, however, a beat em' up, so there's that.
One more I could think of is Epidemic on Ps1. Piss-poor voice acting combined with piss-poor character models equals a damn fine time. FPS game.
Hope this helps. If I think of any more that AREN'T action-y adventure-y I'll post 'em 'ere.