I don't know if you are looking for anything specific but here is a list of some of the games that I would recommend trying:

The Harry Potter games, the PS2 version of these games seem to be heavily inspired by the N64 era Zelda games as they have a lot of similarities. Chamber of Secrets is, at least in my opinion, the best of the three but the other two games are still worth checking out. Also, something interesting to note is that, unlike how games for these systems normally are, the PS2 versions of these games are technically better than both the GameCube and Xbox versions due to porting issues and some other poor design choices.

The Sly cooper games, these games, especially 2 and 3, are speculated to be direct inspiration for the Assassin's Creed games. Some say that Sly 2 is the best, while others say that 3 was the best, but I don't know which one I prefer.

Monster house, I know that this is a bit of a weird one to mention, but it was a really good game. The game is similar to Resident Evil 4 in both gameplay and atmosphere. It's one of the rare examples of a movie licensed game that was actually good.

Pac-Man World 2 and 3, both which are action platformers. I personally prefer 3 but 2 had a better soundtrack (I don't know why they put that much effort in the OST of a Pac-Man game).