I don't understand why he wouldn't want to appear weak to Wilson (who has seen him at his lowest and his worst and is still there for him) and wouldn't mind appearing weak to Cuddy.

Even after sleeping on it, I still hate it. Loved the episode until then, but that last 15 minutes was horribly OOC and just plain wrong.