Not all Mary Sue fiction is in other people's universes (and definitely not all is unauthorised). But you are right that it is about the prominence of the part, a Mary Sue story has that character as very prominent, the "lead character" who is sickeningly better than any others in the story (especially of the same gender) whereas Hitchcock played 'cameo' parts well below the lead in importance.