My day job (before the work from home stuff with this pandemic) involved sharing a large area with other people. Large desks, open space, a programmer's dream space.
Even so, anything above chiclet switches (laptop keyboards, apple stand alone keyboards etc) would be noticeable by others. The company would buy you any keyboard, as long as it fell along those short travel, quiet, keyboards.
So take this with a grain of salt, as it is just an opinion:
From personal experience, there is NO keyboard that we call "mechanical" that doesn't produce a noticeable, distinct, sound. And also from personal experience, there will always be at least one person that's having a bad day, or is just douchy, that will complain or find that sound irritating.
Now it depends on your work environment, your colleagues, your employer...