For well over 10 years, every PC I set up didn't have swap. Never had any problem with it.
That's also my experience, with the disclaimer - that I stated - that I haven't been running Linux for real, heavy workstation use, hence the question more aimed at this use case.
My uses have mostly been on a laptop (which has 'light' use) and a headless box that I use for development purposes. In both cases, no swap, and never had any trouble with it.
But this time, it would be for 'heavy' workstation use, and typically putting the machine in standby when not in use (no hibernation as I said), so potentially relatively long up times.
My conclusion so far is what has been said a few posts ago - I'm going to activate a swap partition on a small dedicated SATA SSD, that will also be used for cache files and otherwise content that changes frequently, so that I limit the wear on the much more expensive, NVMe SSDs that I have.