I would also never put virtual memory on SSDs, especially if I know it's going to be used frequently! And if it's not, there is no point in enabling virtual memory IMO. Kinda case closed. On a typical desktop computer with 32GB+ RAM, you're likely never going to need it at this point unless one of your apps is leaking memory badly... Of course there is no definite answer for all. Your specific use case may require enabling virtual memory so you're certain you never lose any work, if you're using extremely heavy apps such as very high-res photo processing and such, or very heavy simulations.
As to wearing out, even though flash memory tech has improved significantly and write algorithms too, it still has a relatively low number of write cycles before wearing out, so reliability depends a lot on the write algorithms and how they can spread out data and move it around (wear levelling). A "normal workload" doesn't mean much. There is a gigantic difference between a basic user browsing the internet and writing some Word documents, and another heavier user (but still not exceptional) that will record and edit a lot of videos for instance. A difference that can be 10x or 100x more. So whatever normal means... Write algorithms that spread data out have improved drastically, but they are no miracle either. I don't know whether SSD failures these days are mostly due to flash wearing out or other causes. I'd be interested in seeing real and dependable statistics, because what we read most here (and elsewhere) is that it just doesn't happen, but not based on real figures. Another frequent cause as I know is data corruption not due to wear-out but due to a controller's bug rendering data impossible to access. Controllers have become so sophisticated that this kind of bugs are bound to happen occasionally, and it's a significant cause of failure as I've seen.
The point that "Windows knows what it's doing" - I'm not sure how to take this. I can't help finding it funny. What I have observed though is that even when you have ample RAM and are nowhere near actually needing virtual memory, if it's enabled, the swap file will be written to on a regular basis (and leading to huge fragmentation on HDDs, even again when the OS would never actually need it). That was up to Windows 7 and back when I had not disabled it yet and was still using HDDs. Maybe this has changed in more recent versions.
Of course on servers, that can be another story. Disabling virtual memory may not be an option at all. But many or most servers these days still run on HDDs and not SSDs as I reckon.