Finished the main story last night with about 270 moons, I felt the game dipped a little in the later kingdoms, a couple of which are very very short indeed. There is a great kingdom towards the end but its sandwiched in some quite disappointing ones.
A lot of the post-story moons become very close to filler content, there are some notable exceptions and some of them are hard as nails (unlike the main game which is pretty easy for the most part other than a couple of the slightly tougher boss battles).
I'll probably aim to get most of the moons but can't see myself going for 100%, most of the races and some of the mini-games have extra stars that I just wouldn't enjoy getting as I find some of the controls for those bits is a bit sloppy.
I didn't mind the motion controls, not sure they added much though and I think locking out some abilities (and hence some moons) beyond motion controls is pretty poor form.
I think the reviews might have been a touch too glowing, I'd probably give it a solid 9/10. There's heaps of imagination for sure and plenty of smiles and fan service but personally I don't think it'll stand alongside BotW in a few years as an absolute masterpiece.