Obrian said he preferred DS9 because it was broken down. He liked he had a lot to do.
I spent all my time standing around in the transporter room.
Might explain why he was willing to give up a posting to the new flag ship(Enterprise-E) to serve on a space station.
Worf was requested on DS9 by Sisko and it was at a time when there was no Enterprise serving in Starfleet, so between the destruction of the D and the commission of the E. Worf also lamented the loss of the D and was skeptical that the E would ever replace what the D represented to him and he was contemplating leaving Starfleet because of it.
He really had no intention of serving on the E, although to think he would have turned down a request from Riker or Picard to rejoin the crew is stupid.
And the "space station" was only the most important posting in Starfleet as it was the point defense against the Dominion, Cardassians and at the time Klingon Empires and pretty much held sway over most of the Alpha Quadrant.., but you know, fucking around with the Remans and So'na is way more distinguished.
It's 106 miles to Chicago, we got a full tank of gas, half a pack of cigarettes, it's dark... and we're wearing sunglasses.
Blank Yellow (NSFW)
"Mostly Harmless Nutcase"