Howdy Captain Justice, welcome to the greatest community on the Internet!

If you want to see what the engine(s) are really capable of, I'd recommend checking out Dr. Mike's mods, found at Fundament Zero, which DM linked. They really show you how just about anything is possible with enough scripting skill.
If you'd like to see what is available without scripting skill, I might recommend my own much, MUCH lesser creations, which you can find at my site:
https://bentongrey.wordpress.com/I use a wonderful tool called EZScript, which you can find links to there as well, that allows you to use a very simplified scripting language. It can still do tons of cool stuff.
Are any of the modding tutorials still around?