The Spiderman series could have been great, but wasn't. Too much concentration on mass appeal leads to a waterdown product that pleases no one except the masses that are looking for a date movie to watch that isn't too much of anything.
There hasn't been any comic book to movie translation that has been done well. None. All could have been great, but ended up either too corny (read X-men), too boring (read Hulk), or too lame (read Spiderman).
I take that back, Batman one was 100% raw entertainment. A comic book done with just the right amount of realistic human interaction, comic book flare, and camera manipulation to accentuate the outstanding attributes of the series. After I watched Batman in the theatres, I remembered almost every line and was talking about it for 3 months after. Great film back in the day.
Bookmarks