However, I'm finding it hard to find anything online that wants to actually help me except for the tutorial from MacWorld 06. Any pointers for a good tutorial website or some code I can play around with?
And start playing with them. As I said, it would be best if you picked some trivial task you wanted to script with applescript, try to do it, and post what you have and questions here when you have trouble.