The PS3 has an incredible library of games, including action-adventure titles that might scratch that itch. Consider exploring games like Uncharted , God of War , or Horizon Zero Dawn , which offer compelling narratives and engaging gameplay.
The Legend of Zelda: Ocarina of Time is widely considered one of the greatest games ever made, but it never came to any Sony console. However, if you have a (CFW or HEN), you can run N64 emulators and play OoT. This post explains how — legally (provided you dump your own game ROM).