What made him so good? And why doesnt he work on Bethesda if he is so good?
That's just a bit of a hyperbole. All that makes me special is that I've been around for a few years and I've contributed a fair number of scripting resources, such as my http://cipscis.com/fallout/utilities/validator.aspx and http://cipscis.com/fallout/tutorials/, and answering a lot of scripting questions on these and other forums. I'm certainly not one of the more prolific modders out there - if you look me up on any of the Nexus sites you'll see I've only authoured a few small mods on my own - but I've helped a lot of other modders out so you'll probably see my name come up fairly often if you're interested in scripting.
As far as I know, Bethesda doesn't have a habit of hiring modders. Even if they did, there are far better modders out there than I, although I have been fortunate enough to be interviewed on their blog about 18 months ago - http://bethblog.com/index.php/2009/08/24/modding-interview-cipscis/
Now that I'm back from my Summer vacation, I'm going to try to be more active here again, hopefully making more progress on my validator.
With regard to your original questions, as far as I know my website is where you'll be able to find most Fallout-related scripting tutorials (applicable to both Fallout 3 and New Vegas), and the
GECK Wiki is best used for things like looking up function documentation in its current state. The script extender is great in that it allows you to do some much more interesting things with the scripting language, which is pretty bland by default, such as looping and working with form lists in more complex ways. It's not required for every project, though, so you might not always find it necessary.
Cipscis