I have completed every game 100%
64 was also one of the first games I ever played
these are the objective rankings

odyssey>sunshine>64≥galaxy 2>3d world>galaxy

odyssey is perfect, it's the best parts of 64 and sunshine on steroids and refined along with having a plethora of new amazing things, I honestly could not want more from a video game

sunshine is amazing and none of the parts people bitch about are even a problem, exploring the comfy levels looking for blue coins and finding creative ways to use your amazing moveset to collect them and take shortcuts is fucking fun

64 is great but it really starts shitting the bed once you get upstairs, most of the levels after that point are frustrating and terrible

galaxy 2 suffers from the completely neutered movement mechanics of the first game but it's so consistently creative and amazingly designed I put it on par with the first three, it also never frustrated me at any point like 64
it basically has no bad parts at all but I can't overlook the awful movement mechanics, it just utilizes them much better than galaxy

3d world actually has better mechanics than the galaxies and is fun to move around in, but not nearly to the extent of the top 3 and while the levels are fun they really just don't give the same kind of satisfaction
it's basically a 2d Mario but in 3D, which is fun but pretty empty feeling compared to galaxy 2 which I think did the more focused and linear stuff with way more soul to the point I prefer it
it also gets annoying towards the end with shittier levels similar to 64 and also has autoscrollers which are cancer

galaxy is absolutely the worst, it is so fucking boring I could barely 120 star it even a single time
it has the terrible mechanics but also empty half baked levels because they weren't willing to commit like they did in galaxy 2 and it's just a chore to play most of the time
rosalina and the storybook are what redeem it but a boring slog is all it is as a game