The key to a quiet desktop is having large, slow-moving fans for the case.
120 mm or even larger in size.
There are also other considerations that will remove noise.
Without CD/DVD drives in most modern computers
(the ones that used to sound like a Lear jet), that's not as big a problem these days.
Sometimes a hard drive will be noisy, especially the spinning 10,000 rpm type,
but now you can get an SSD.
Some computer cases seem to have padding to make them less noisy.
Some processor fans advertise that they are especially quiet.
I also wonder if a GeForce GTX1650 or 1660 would be sufficient to handle new adventure games over the next few years, or if I should get a more powerful graphics card?
I think those two models would be fine for upcoming adventure games for the foreseeable future,
including the more demanding 3D types.
If you check system requirements for Syberia 4 and Beyond a Steel Sky, those two cards
you mentioned are way over the recommended requirements.