In my experience, EE is not any more difficult to learn or get your head around than basic HTML/CSS. Most EE functions are abstracted away from the underlaying PHP, and if you ever need to, you can get into that.
It’s a very rewarding experience to develop with EE, as you’ll build skills to allow you to actually execute what you have in mind when you think of it, rather than relying on the expensive and trouble of hiring a developer, then explaining to them what you want and hoping you’re communicating clearly enough to make it happen.
“Scripts” isn’t quite what I’d describe EE and related add-ons as… What they do is a little more complex than that. EE is essentially a set of front-end development tools powered by PHP for a MySQL database, a model sometimes called “LAMP”. Edit: Wiki link is broken, just Google that…
You could write it yourself from the ground up, or hire developers… EE makes it pretty easy to do it yourself and learn along the way.
In terms of support, that’s what these forums are! 😊 There are also a lot of great tutorials out there. I highly recommend Ryan Ireland’s series as a start ($5 per episode, or $60 for the series - worth your investment!). This is how I got my start with my first EE site, which is still running with great success today.
The advantage to doing it yourself is that you’ll understand your process all the way through… You may find that what you have in mind right now needs to pivot a bit before it’s really ready. EE will help you build whatever it is that you have in mind, and provides a very flexible way to do more with it later down the road.
I love having my clients come to me and say, “So we had a thought…” in regards to the site I’ve built for them, and not getting that cold, sinking feeling, because I know I can probably do what they’ll want pretty easily in EE.