Tutorials

After Effects Basic Training – 10 Free Lessons

VIDEO COPILOT | Professional After Effects Tutorials, Plug-ins & Pre-Keyed Stock Footage
            Free Stock-Pack Appreciation Day

From Forum Post: Effects availible for Lightworks

Revisionfx primere effects
Pete warden after effects 
Top Video Editing Effects According to About.com
144 After Effects Plug-Ins
New Blue Cartoonr effect
Free Frame effects
The Plugin Site – might be very out dated
StevenGotz Plugins
Tool farm<-pretty much a big list of links to plugins for effects