Obviously, it is literally the only released card with those aims that isn't from the past decade. With small workarounds, you can also use a low profile RX 6600 without PCIe, and at the power limit, it still outperforms it by over 30%, but almost nobody does because...
This is a niche that is no longer relevant. Ultra-small ITX (the only time when you would care about skipping a power connector) are getting replaced by upgradeable mini-PCs, at a fraction of the price. And from a power performance point of view, a mobile card makes way more sense, or integrated graphics. A RTX 4060 Mobile almost doubles the performance of the RTX 3060 6GB, and the RX 7600M isn't far, while the 780M matches the performance of the RTX 3060 6GB while using 35W for the whole system.
The RX 580 8GB definitively gives it a competition (and at just a marginally higher 100W TDP from most sellers now), it falls in some modern games (which the RTX 3050 6GB cannot run at all unless going 540p), but it will run all older games and most applications just as good or better at times than the RTX 3050 6GB, while costing nothingburger and saving the environment from some e-waste. Unsold RTX 3050 6GB will just be dismantled to become Switch 2s next year.
The only reason I would advise somebody to buy a RTX 3050 (6GB or 8GB) is because they need CUDA for work, with low performance requirements and/or low budget, or I guess if you want to hold in a niche ITX case that will break and destroy itself unless you avoid using a power connector, and you do not want to deal with tweaking a RX 6600 for the job.