For those who live/work alone and want to continue doing so, yes, that’s the current hotness for those with the means.
For those who have partners or colleagues they do not wish to alienate with the deafening sound of their typing, the choices are more limited. The Matias Quiet pro looks great on paper but is made by a company that turns out overpriced cheap junk that will break quickly. In the land of Cherry switches, you need to specify not just one of the non-clicky switches, but also rubber rings under each keycap to mute the clack of the keycap meeting the base of the switch. Key travel suffers as a result.
After far too much research, I landed once again on buying a keyboard made 20 or 30 years ago – both the Apple Extended Keyboard II and certain Silicon Graphics keyboards were built using “Cream [or white] Damped Alps” switches. They feel heavenly but are whisper quiet. The Matias quiet switches are a rather mushy attempt to replicate their feel. The Apple option is fairly cheap - you can find one for less than $50 on ebay - but you will need to train your fingers to accept that the home row nubs are on the wrong keys. The SGI route gets you a standard PC layout with the home row nubs in the right place and no windows keys (this is a feature, not a bug, for me), but costs a minimum of $100 and $150 or even more is common.
In both cases, you’ll need a modern PS/2 or ADB to USB adapter - Imate adapters are becoming quite costly and a generic PS/2 adapter won’t work - budget $40 for a programmable adapter made by and for keyboard snobs, search the Geekhack forums. Another $10-ish will get you a new-old-stock Apple ADB cable, but here’s a secret - you can use any generic S-video cable.