Zero desire to advance is a good one.

IIRC Riker has turned down multiple offers to become a captain of his own ship, to stay as Picard's #2. This would've never happened in real life, he would've been gone after Season 2 at the latest.