You're getting what you are buying, a fully functioning RTX 4090D with 48gb. But I would hope people do not buy it for exclusively gaming as the blower cool sounds like a room tower fan at lowest fan speed and a jet engine at max fan speed.
There seems to be an issue with the vBIOS on the card preventing the memory from ever clocking down for a low power state, so this card will never really idle and drop under 50W usage.
Everything else is fine and with an undervolt on 900mV you can retain near full performance with power usage of 300W under load which lets you lock the fan to its lowest setting and still stay cool enough.