One thing I don't get is the elitism Starfleet has about senior officers .
In Tapestry, Picard said that being a simple science officer was boring and beneath him. He might have insulted Dax, Obrien, and a whole load of characters.
Just being an officer is cool in itself, you've got authority and respect, and get to do a job you're good at.
Who absolutely needs to be captain in charge of everything at every moment, getting glory every second?