And if ya go by the novels, Scotty gets back to Earth, becomes a host of a bar, and winds up in charge of Starfleet's Corps of Engineers before gettin' command of a Galaxy class starship.
It's fanficcy crap like this that makes me dislike the novels.
Of course, taken out of context like that most of Trek reads like TNG season 8
. Those novels were great reads, especially Indistinguishable From Magic