Not exactly a plot hole, more of a “are we getting a sequel or aren’t we” moment. But it has always bothered me that the ending scene with Mary Jane in Spider-man (2002) very heavily implies she has just realized Peter is Spider-man. Then the second movie starts and she’s mad at him for being “flaky” and seems to have no notions he could be busy being a superhero.