I think most of it is probably from having the TNG characters somewhat shoehorned into another show’s finale. I personally think the episode would have been a lot better without them, but I don’t think it’s nearly as bad as it’s made out to be.