Depending on what your website is going to be for, Wordpress is also a really great option. Although it's primarily a blog-style CMS, it can be used for a lot more. It's also really customizable, with themes available basically everywhere on the internet for every purpose, and it's not difficult to create your own themes (although to get them to look pretty may take a little while).
Wordpress by itself isn't a fully-fledged website, as you'll need somewhere to host it. There's a lot of free hosting services out there (X10 and 000WebHost are some of the more popular ones I believe), and you can install Wordpress through their control panel most of the time using a service like Softaculous. Most hosts usually have a tutorial you can follow.
Alternatively, if you like the sound of Wordpress but don't really want to go through the hassle of hosting it yourself, you could use Wordpress.com. It's less like the Wordpress CMS and more like an enhanced version of Tumblr, but it may suit your needs depending on what you want it to do.
Still trying to get better designs, I'm still only an intermediate at CSS.
I wouldn't go so far as to say useless, but I do agree that it's best if a person is into tech stuff that they just learn the technologies you mentioned. I hate using templates or site builders, I prefer to code everything by hand with Editpad Pro. Granted, not everyone is a techie and wants to learn all that stuff. In that case, Wordpress and the like are fine. I prefer the manual option though because then you know every "nut and bolt" of your site.
The reason people use website builders is almost always because they're irrationally scared of the idea of writing code, or they can't tell the difference between a well designed site and one made using a free WYSIWYG tool.