^^^Agreed. There would be no drama or interest if everybody was worshipping the ground he walked on. Part of the point - at least what I got - was that Scotty himself wasn't willing to accept that he had to change and adapt to his new situation. He WANTED everyone to kiss his butt, and got upset when they wouldn't, such as Geordi wanting to do his job instead of listening to someone who is 70 years behind the technology. When Picard mentioned studying up, Scotty refused.
That this story was told with a character who was loved and revered by so many fans made the point even more emotionally.