There are a gazillion YouTube tutorials for Blender showing you how to make some very cool stuff. Some of the newer tutorials using Blender's Cycles renderer creates photorealistic images without much effort.

Just make sure that you get recent tutorials - there is probably stuff from pre-2.5 Blender floating around that would be confusing to anyone using newer versions.