Website I went through:
http://www.google.ca/search?gcx=c&sourceid=chrome&ie=UTF-8&q=special+effects
http://en.wikipedia.org/wiki/Special_effect
http://www.denofgeek.com/movies/177951/top_50_movie_special_effects_shots.html
http://www.airmagicfx.com/
http://www.thomasfx.com/
http://www.youtube.com/watch?v=2b97KIlJuYs
http://www.youtube.com/watch?v=JmD7ysB62P8&feature=related
http://www.youtube.com/watch?v=8dTY6AvC93g&feature=related
Some were interesting and most I want to try and at least do.
Here are more websites that I found interesting:
http://www.pyrotekfx.com/
http://www.mediacollege.com/video/special-effects/
http://www.mightycoach.com/articles/specialeffects/
http://www.adobe.com/products/aftereffects.html
http://www.cracked.com/article_19140_8-movie-special-effects-you-wont-believe-arent-cgi.html
http://www.borisfx.com/tutorials/
Some of these arent to useful but interesting to know or go through.
http://www.videocopilot.net/ This website very cool and useful.
http://www.videocopilot.net/tutorials/
http://www.videocopilot.net/blog/2011/09/video-crazy-driving/ (http://vimeo.com/29395697) same one
http://vimeo.com/user522429 Andrew Kramer