I don't often get hyped up for a game, with a new Zelda game that is trying something new I wanted to give it a fair chance. I got it day 1 with the Switch and I thought it was a good game, if I was forced to give it rating I'd say 7/10. As time passed (about 105 hours) I lost interest and never finished the game so maybe it's more a 5/10 for me now, though I did do all 4 of the temples so I could probably go back and tackle Ganon's castle. I doubt I'll buy the sequel on day 1 (I don't know anything about it so far, so there's still a chance), I think I'll wait a long time and pick it up cheap.
I'd say any single player game that gets you to play 105 hours (and you haven't even beaten it yet!) is pretty incredible. Maybe you should have just tried to beat it after like 80 or 90 hours instead of keep going and eventually lose interest racking up an insane amount of playtime. No matter how good any single player game is, eventually you're gonna get tired of it if you keep playing it. Seems weird to downgrade your score just cuz you played the game to death. I mean, you're saying you put over 100 hours into a game you give a 5 out of 10. That's pretty bizarre.