Another little observation, Ghost, if you’ll indulge me…
By your own admission, you aren’t really a big fan of writing code, but you are obviously good at seeing the potential in an idea or an effect and visualising how it would come across in a game. You strike me as more of a concept designer than a scripter. An (extreme) example is Apple’s Steve Jobs. I doubt he knows very much about design or engineering, but he has originated most/all of Apple’s famous products by understanding what works and what doesn’t. It’s probably not a bad line of work to be in. Steve has certainly done OK for himself. Basically, I am saying that you don’t have to be a scripter to be involved with game production.
I can see exactly why you ask the kinds of questions that you do because Unity almost allows you to work like that. It’s a bit like making a model from Lego, which offers some very sophisticated components (motors, pneumatics, etc) that you can just plug in. And it’s not uncommon for programming languages nowadays to offer powerful modules that require little coding skill. Indeed many good “mash-up” websites are simply powerful APIs (Google Maps, Amazon, etc) glued together with off-the-shelf code.
Unity has much better modularity features than even Perl or PHP, but these languages have been established so long that there’s a good chance any code you need will already have been written by an expert somewhere and you just need to find it. Unity may well develop this kind of resource base eventually, but it hasn’t got there just yet.
In short, Ghost, I don’t blame you for having the mash-up philosophy, because that is how a lot of good stuff is achieved nowadays and it’s doubtless what you have grown up with and come to expect from technology. But you’re probably a good year or two ahead of where Unity is currently at. I think you are exactly the kind of person who could help develop the Unity resource base, though. Aim to have a really good, up-to-date knowledge of what is available on the wiki, etc, and base your projects mostly around that. Try to offer a bit of background to your questions, explaining what you have tried and why it didn’t work. And try floating script ideas and game concepts, discussing what kinds of scripts you would like to see, and why. You would probably make better progress and it would be a very useful contribution to the community. (Have a look at the BBC’s Backstage website for a good example of this kind of discussion applied to web technology.)
However, having said all that, if you really want to get into coding then I’m afraid I have to repeat what the others have said. You would need an awful lot of experience to tackle some of the things that you ask for help with. I doubt anybody could learn to write code by struggling with such difficult tasks.