This thread has been going for almost 2 years, since August 2010. It has helped me as well as many other androidforums users to automate a lot of things on their phones using one of the best and most powerful Android apps every created - Tasker
Tasker can be quite difficult for some people to set up, but this thread is full of useful step by step tutorials for great profiles and a lot of members subscribed to it to answer questions.
The fact that this thread is still going strong for this long is proof that it is one of the best threads ever on here!!