I actually did like the "lighter" moments in INSURRECTION just because it's nice to see the TNG crew loosen up after two heavy films. I think going for something lighthearted like THE VOYAGE HOME was the right call by Piller, but the suits wanted it to be an action film as well so it ended up as a jumbled mess.
ST09 isn't the worst film, but it does have the worst moment with Kirk running around with Nutty Professor hands. That attempt at slapstick comedy is just aaaaaaawwwful, especially given the context of Kirk trying to warn everyone of impending doom. This is why I usually lump the film with the TRANSFORMERS flicks, because it feels like something you'd see Shia doing on those flicks, frantically running around on a comedic note.