Madara also looked rather pathetic during his time as a Juubi Jin. I expected more from him but I expected even more from Kaguya which is probably why I was massively dissapointed. Sure, Kishi tried to "redeem" her through the databook but I cannot unsee what I saw happen in the manga. I was expecting a Hamura powerup for Naruto and Sasuke as well so they can fight her.
I'll blame the deadlines though. I also believe Madara got played out that way because Kishi had to hurry up and finish the manga. If he had more time, I would've hoped for a final fight against Madara and then Kaguya to emerge after that fight. Then she gets defeated by Naruto and Sasuke after they receive Hamura's power which would put them at Hagoromo and Hamura's level (Since they'd each have half of both Hagoromo and Hamura's power).
Regardless, I prefer Kaguya as the final villain. If she was written differently...