Perhaps you read a different Spider-man comic than I do, but the thing that has always made him endearing and entertaining is Peter Parker, not his ability to lift 10 tons.
I thought they did a very good job of establishing who he was and why he was that way. The hardest thing to establish for a super hero is why the hell are they using their powers thanklessly to save innocents? It's the hardest, most unappreciated, most dangerous path out there. Besides that it means that anytime someone wants you they can just threaten anyone until you show up. And kill them if they please to discredit you.
Giving emotional attachment to the character allows you to understand his losses and thought patterns which allows you to agree with his choices.
Batman never established that. Batman was a cold rich millionaire who goes out every night to fight crime in the movie. The original Batman movie was my favorite comic book movie at the time, but Spiderman surpassed it with its honest treatment of the material, interesting developments outside of special effects/techno gadgets (i.e. Norman and Harry, Harry and MJ, MJ and Peter, Peter and Harry, Norman and Peter).
Spiderman has always been a relatively low-power super hero taking on relatively low power villains in more personal situations. The green goblin is a good foil for him because his power is limited (he can't just blast him into oblivion or mind wipe him, nor is he juggernaut or colossus or the hulk or some other creature too durable for Spidey to damage) enough for him to be a threat but not unsurpassable, he has a personal connection to Spidey (Norman to Peter connection, and insane goblin to Spidey once goblin knows Peter is Spidey), and because they share a similar situation (power in a relatively power free city at the time, and the choice of what to do with it).
Good movie. Well done, especially within a Hollywood time limit and talent budget. Especially well done considering the quality of Tobey Maguire's and Willem Dafoe's performances in a movie that could have pandered to the cartoon watching children to sell toys and make more money. (Because honestly, they didn't have to make an adult movie, the fans would have come anyways, they would have been pissed, but Hollywood still would have had its money.)