His character is some sort of hereditary noble who also happens to be the most decorated captain in starfleet, in command of the fleet flagship, allowed to galavant about with little to no effective oversight... Oh, and he quickly befriends a literal god, who watches over him from then on.

I don't think "lack of power" is one of Picard's defining attributes