Heh, i found if i had a 6-8 powered external hub, 1 port to power the Pi, then use a USB port to extend the ports to 5-7, and it was quite usable. Seems convoluted until you think that the USB to the pi is only for power, in which case it's not confusing at all.

Mhmm... I know i'd like to see if there is a way to harness unused cycles on terminals in that configuration to make a scalable super computer. Although to what degree i'm not sure. I just like compiling and doing stuff locally as well. Hmmm..

Well, the port labeled "USB" can be used (though not at the same time):
* As a host port, provided that you have the proper USB OTG cable. Connect a hub (or a hub-like device, like the Raspberry Pi keyboard) and you can have multiple USB devices, though there might be power concerns here.
* As a peripheral port. You can have the Pi Zero act as many different types of USB devices, including mass storage, serial (connect to it without a network), ethernet (make a network to connect to it), and even things like MIDI. I have actually managed to boot a computer using the Raspberry Pi as a USB drive to boot from (though this didn't seem to work with composite configurations).

On my local store Raspi 4 1gig is available for more than a week now.
Both 2 and 4 gigs are planed to "first days of july", whatever that means.

For those of you in US the atomic pi it's probably a better deal. It has some drawbacks but is cheaper than the pi 2Gb, 16Gb emmc, faster (I guess) and can run windows for anyone interested. For gaming is a nice little SBC.
For us in EU, well, the pi is half the price because of shipping, wich is more expensive than the board itself.

Edit: Oh crap, I only noticed the OP is from 24 june after posting... Shame on me

I've got a Pi set up with Retropie for my retrogaming needs. With the newer ones, it appears they're almost ready to be a basic desktop computer.

I saw a video recently of somebody that added a board to control electricity to lamps for home automation.

Wrong again. They may've let you order it, but that doesn't mean it would've shipped. It lists the date as a pre-order for July 17th, so, what would've happened is you order it *expecting* it to ship, and it would've been delayed until the actual release date. Welcome to product release 101.
They seem a lot more capable, but there's little reason to upgrade if you already have one set up unless they release some emulators that the 3B couldn't handle. As of now, the ones unsupported (3D0, Jaguar (technically there but it doesn't work for anything I've tried), Saturn, et al) are so not because of lack of capability, but because no one's bothered to better code what exists. Better use of money would be to rig up a good cooling solution on it so it doesn't thermally throttle.

I'm specifically referring to the micro USB port that's only for power. The USB port(s) of course are untouched.

That's more or less my impression. I've got both one of the first gen Pis as well as the 3 and I don't particularly see any reason to upgrade at the present time. I'm far more likely to just get upgrades for the current Pis I have.

The hat to control mains voltage is particularly intriguing. I might get one of those and set up my older Pi to power cycle my modem when I lose connection.