In particular, it is better than other VPN/port forwarding type solutions because it works transparently and universally. It works on your phone (where VPN can be more tricky). It works in environments where you aren't allowed to install special relay software. It works when you are a guest somewhere else without them having to change their network setup.
As for cloud services... yes and no. In a world with direct addressing you open up many opportunities for innovation in the home cloud appliance market. However, many cloud services are made affordable because they can leverage shared infrastructure, sell usage metadata, or add and remove capacity instantly. Whether home based solutions could be competitive in price and reliability without those abilities. I see some categories of service that it makes sense for, others, less so.
Security is a concern, yes, but one that can and should be addressed by good security tools and practices (firewalls, automatic security updates, good backups, not running services you don't use, etc) not by crippling your network with NAT.