I thought doing a clean install once in (long) while is a good thing?
How do these rumors get started? Perhaps it's a Windows thing, like so many other indignities its users endure.
I have performed nothing but upgrade installations on all my Macs, forever, going back to the original OS X public beta, which I also installed as an upgrade from OS 9, which was upgraded from OS 8... etc.
For new Macs I use Migration Assistant, which migrates all possible compatible code from the Macs they replace. Needless to say I have no idea what programs you require, but to install everything anew that I require would be untenable.
To cite a trivial example if you perform an "erase and install" you might find it impossible to use old printers, rendering them landfill fodder. My original Apple ImageWriter still works. It's over thirty years old. Upgrading macOS is what continues to make it viable, whereas an "erase and install" would render it literally impossible to install with Mojave. (Side note: it's not long for this world though, due to the impending sunset of all 32 bit code).
Over the past decade or two I dragged incompatible programs originally written for the Motorola 68000 or PowerPC code to the Trash. That describes the full extent of any "housekeeping" I've ever done.
(although that probably has more to do with my lack of ram---i have 8gb.)
What lack of RAM? macOS runs perfectly fine with half as much, and requires only 2 GB. Another urban legend debunked. The difference is that recent macOS versions have grown to rely more upon virtual memory than before, so if you have a traditional rotating hard disk drive it's going be slow, regardless of how much physical RAM is installed.
If your Mac relies upon a rotating hard disk (as opposed to flash memory) you can install 64 GB and it will still be slow.
Bear in mind these facts: Apple has been designing iOS for flash memory since its inception, that macOS has been inexorably becoming indistinguishable from iOS (they share a lot of completely identical code and use completely identical file systems), iOS devices traditionally had limited memory resources but have always used flash memory for storage, and that nearly every new Mac uses flash memory. For evaluation purposes, go ahead and install Mojave on an external hard disk drive (and I encourage you to do so) but expect it to work slowly.