Depends on the game. I don't know until I play it.

GTA IV got tiresome. I got sick of GTA V after I'd finished the story missions.

Ocarina of Time's overworld is alright enough, and excellent for what it was, but Wind Waker's world blows it out of, uh, the water.

Assassin's Creed 2, Brotherhood, and Revelations were binge-fests for me. Same with Wind Waker. Burnout Paradise and Mass Effect took some time, partly due to the learning curve, but I came to adore them. I especially liked the Mako exploration, even though it generally sucked--it had good elements to it, I just want it improved. MGSV and Just Cause 2 get repetitive, but I tend to binge those once I've gotten into them after taking a break for a while.

Oblivion, Skyrim, and Minecraft are fine when they're new, or when I get a new mod to try it, but once I've gotten tired of it all, I can't go back.

Assassin's Creed 3 just flat-out sucked, and killed my remaining interest in the series after Revelations' story blunders. I never finished it.

Majora's Mask is the only open world game I like.

For some reason I never put zelda games in that category.