I confused rpgs with adventure games. It's been awhile since I played an adventure game.
As for battle triggers. There was a long path in Final fantasy 10. I just wanted to walk to the end of the path and continue the story, but battles kept activating and I ended up not finishing the game because of it.
Oblivion sometimes felt adventurish to me, lots of interaction with the npcs like an adventure game.
I think the last adventure game I played was broken sword 3.
My favourite thing in broken sword was showing the npcs the tissue. Broken sword 2, the maggot. Broken sword 3 didn't have a funny item to show people, it disappointed me.
Something I don't like in adventure games is fake choices. Where either choice you make ends up with the same outcome. Such as "do we go left or right" and either choice ends up with you going left.