Is this really a thing in the US? At least in Europe, rooftop solar like OP mentioned doesn't require grid-connection?

Only some states allow simple plug in roof top or balcony solar I believe. So depending on your area you might be required to do a grid hookup and lose access to it during outages.