I've read a bit about the production of the episode, and that, coupled with other things I've read about Berman's opinion of TOS, has contributed to my current dislike of this episode. James Doohan is, as always, fantastic as Scotty, but he has little with which to work. While Moore says he came up with the idea that LaForge would be annoyed with Scotty and not know who he is, it seems to me this wasn't Moore's original idea.
It's been 80 or so years, but there's no way that Geordi, a huge engineering geek, wouldn't know who Montgomery Scott. Not to mention that Scotty, along with the rest of the 1701 command crew, took part in events that were far from ordinary and which shaped not only their era but the future as well. Mr. History Buff himself, Picard, would have also been thrilled to get to know Scotty. There's no way he wouldn't have held a dinner for him with the command crew and maybe even a Q&A with the crew somehow.
Granted, that's not exactly the most exciting material, but it could have happened along with the Dyson's sphere and the Jenolan being trapped. As with "Unification" and "Generations," the sense that Rick Berman neither knew or cared about TOS or its legacy is glaring here.
It's also Berman who shot down what Generations should have been by refusing to allow Nimoy to discuss script rewrites and direct the film. It makes zero sense that Generations wasn't "The Search For Kirk" with Spock, McCoy, AND Scotty alive in the 24th century. They should have been front and center in the 24th century portion and the entire command crew (including Sulu) could have been present on the Enterprise-B. This would have, of course, taken too much of the focus away from the TNG cast.
The third through seventh seasons of TNG continue to age poorly for me. The characters are so damned smug and arrogant and self-righteous and this colors how they interact with legends like Spock and Scotty.