The busy writer producer talks about his latest projects including Star Trek 2, Cowboys and Aliens, and Transformers Prime