I have one of these to help cool an second, lower (on the mobo) NVMe that the normal aesthetic aluminum slab "heatsink" on the mobo couldn't. Main thing I don't like is that it's effectively installed "backwards", pushing air against the flow coming from front-mounted fans, and looking rather out-of-place when everything else is set up in front-back and bottom-up airflow pattern. Noise at full power isn't very notable vs the soft "whoosh" of air coming from the front fans (which were set at a higher RPM more to pull air through the fine dust filters I installed for dust management). My main concern is actually the longevity of the fan, as it doesn't look like replacement fans are readily available and if it somehow dies, I'd have to rubber-band or zip-tie a tiny Noctua to it, further ruining the aesthetic.
Installing it with the fan facing the proper way is a major PITA, if not borderline impossible, simply due to the way the copper pipe is in the way of the M.2 screw even when angled off.