I liked this episode a lot, because it was one of those few times original TOS characters had a prominent role. However, I did have some problems with it. Scotty came across to me as too needy and the whole "padding of estimates for the captain" thing was overdone.I hated this episode and everything they did to Scotty, anyways. Not a happy ending at all..... alone in a shuttle in a future where you know nobody and all your loved ones are dead, and everything you know, even your most amazing skills and abilities, have been overshadowed and surpassed. This was a miserable end for a beloved character.
Frankly, the fact that Scotty was rescued and brought back to life some 80 years later makes him a human time capsule. I would think the Federation would extend a hearty invitation to him, for a full debriefing and perhaps the opportunity to give some speeches about his time aboard the early USS Enterprise. Instead, he gets a shuttle and is left to depart with no indication of where he's going (he decided not to go to the Norpin Colony). Previously, he WAS heading to retirement... why wouldn't he continue to do so? It's not like the transporter buffer rejuvenated him. Or perhaps, his experience with Geordi in engineering ignited his explorer spirit. Whatever the case, I wish they'd set it up as more celebratory, rather than a "cast off." You can bet ANYTHING that if it were Captain Kirk, this would be the case!