The ThermalTake "Starforce" LED fans have the glitz. I have no personal experience with them, but that model was preceded by another "LED" adjustable 92mm fan -- can't remember what it was called -- it had a motor-whine at the top end of about 3,600 rpm.
Similarly adjustable -- also "LED" -- ThermalTake make a 92mm "Blue LED" fan. In a batch of them, some of them only exhibit white-noise from turbulence, others, a slight whine. They spin up to 3,600 rpm top-end.
Personally, I'd choose a Panaflo and control it from the CPU_FAN pinouts on the mobo.
I was NOT impressed with the Enermax line of adjustable fans. I didn't have their 92mm offering, but I bought two 120mm fans of the same sort. It didn't look as though their monitoring circuit was accurate. They were rated "up to 2,800" rpm, but with the rheostat turned on full-bore, I don't think they would spin past 2,200. You may want to run the fan below 2,200, and they ARE reasonably quiet, but frankly -- I think they are a greater instance of "schlock" than some of the ThermalTake offering.
Some have recommended the ThermalTake "Silent-Cat". That's another one to consider.