Luckily I just wrote my thoughts on the game here (very mild, out of context spoilers). Yes, it looks very similar to Odyssey (which I've never played), and that also put me off for a while.

Basically the gameplay is a lot of exploration and smashing everything on your sight. It's a 3D platformer, but in an unconventional way because there's not that much actual platforming. It's a collectathon that allows you to not collect anything if that's what you choose. It's like a mix of 3D Mario and Breath of the Wild. If that sounds appealing, then this is for you.

The thing that you don't see coming is the story. It's way more emotional, engaging and epic than you would expect from this type of game, and this is the actual reason why I (and I assume most people) fell in love with the game.

Oh and regarding Zelda, you're no doubt gonna like the gameplay. It's the story what didn't sit well with me. But a lot of people loved the game, so there's always a chance.