Chuck Anderson aka NoPattern is definitely a master when it comes to light effects, he can turn any simple image into a whole different world with all the lights and effects he usually adds to his compositions, that's why his been working for the biggest companies out there, check it out.
Abduzeedo is a blog about design. There are all sorts of articles for those who want to look for inspiration. Also you will find very useful tutorials for the most used applications out there, with a special selection of Photoshop Tutorials and Illustrator Tutorials. Of course there are other softwares conteplated like Pixelmator, Fireworks, and web design tutorials.