Have you ever seen the Next Generation episode..... Relics ? Episode 4, Season 6. One of my absolute favorites!
James Doohan reprises his role as 'Captain' Montgomery Scott. Everything from a Dyson's Sphere plot, to
how 'Scotty' came to meet up with The Next Generation crew, and his interactions with Captain Picard, and Geordi Le Forge are great!
There's also good comedy.... the way he & Worf glare at each other, and of course, his meeting with Data in 10 Forward... "Synthetic Alcohol, and now Synthetic People".... LOL.
A must for any Star Trek fan.....