Sil-Air compressors are indeed silent and great for apartment use. The only real sound is the "POP" of the engine turning on and off as excess air pressure is released. It sounds like a cap gun going off each time, but that's it.
I used non-oiled air compressors before and they were lound as a jackhammer. I had to wear ear muffs with those. With Sil-Air, I don't need any hearing protection.
However, bear in mind that Sil-Air compressors are heavy (50 pounds with oil in the tank) and are considered "expendable" by the company. At 50 pounds, it is hard to move around, especially upstairs, even with the carrying handle.
I had the (ahem) "pleasure" of repairing my Sil-Air compressor and it was expensive! I was at fault for pushing my rolling computer chair too far in under my desk where my air compressor was sitting and one chair leg pushed right into the frontal plumbing and busted the control unit and pipe works. It cost me about half the price of a new Sil-Air compressor to fix it since all spare parts are made in Italy. As such, one could buy a whole brand new "non-oiled" loud compressor for the price of my repairs. Sil-Air usually considers their compressors too heavy to ship back for repairs so most times if something breaks, you either buy the spare parts to repair it yourself, ship it back to the manufacturer for repair (and at 50 pounds, it could be an expensive delivery bill), or throw it out and buy a new one. There aren't many Sil-Air repair shops locally.
My instructions were pretty bad...one sheet of 2D line drawings that don't make much sense. However, I had an older model so I don't know how the newer model instructions are.
A lot of the repair work was performed by me taking photos of the original setup and then using those photos to construct the new piping. However, once the Sil-Air works, it is a dream, silent, and the pressure most times is dead-exact as the pressure gauge reads. The moisture trap works well. The control unit maintains the pressure pretty darn well and there's enough air in the tank to recharge perhaps once every minute at 15 psi, meaning that the motor doesn't constantly run all the time...it turns off when the pressure is reached and then turns back on to maintain that pressure and then off when reached again.
While one could buy a cheaper non-oiled compressor (like a tire compressor), the good thing about Sil-Air is that it comes with everything set up ready to use: pressure gauge, moisture trap, oil, control unit, fittings, etc. all plumbed as one unit. All one needs to do is fill it with oil, screw on the airhose and airbrush, and you're "good to go." With other non-oiled compressors, one has to figure out how to attach the moisture trap, gauge, pipe fittings, and other contraptions which may or may not work out.
Hope this helps.