I just went and saw it yesterday and really liked it. I too was a bit surprised though with a couple of the scenes considering it was pretty obvious that parents would be taking their kids to the movie.

For me though, I thought it was great. I mean we are talking about a movie based upon a comic book. The effects should be sort of crude IMO. All I could think while watching most of it though was, "Man, Peter Parker is having just one heck of a bad day!"