1. There are these things called firmware and APIs, to allow access to the functions that hardware can provide, even functions not originally envisaged by the manufacturers. An SSHD manufacturer could provide firmware with an API to allow it to be used as reserved memory cache.
That's a nice 'what if', but Google tells me that this hasn't happened and your original comment seem to convey this is something that is practical today, it is not.
2. 24GB of RAM on a workstation, and it still wants to swap? That's either lazy work practices, sloppy application software
Honestly, I think my application software is fine and I view the ability to deploy software into my test virtual machines that have very specific unusual and common setups running on my system with integration with the host's visual studio is a God send where both reproducing issues and testing is concerned. This is also while running all my productivity software (I usually have three or four apps from adobe creative suite open), chat software (ie: Skype) and a browser with numerous tabs open.
or you need to consider a minicomputer for your work. I used to run a minicomputer with 48 MB of main memory - yes, megabytes - supporting ~200 green screen terminals and a similar number of PCs - and they had sub-second response times with interactive application software. If a 24GB workstation still wants to swap memory pages, you're asking too much of it.
If a 24GiB workstation still wants to swap, it's because I am using that memory. My next system will likely feature 128GiB of RAM though.
As for mini computers, I guess the modern equivalent these days is a Chromebook - It would just be moving my work from a workstation to somewhere else, not really helpful.
3. What I do on my PC earns me money, is that not worthwhile?
Sure, it's good to earn money. But my understanding of the term 'worthwhile' is to do with importance or significance. I don't consider working in say, a fish 'n chip shop be 'worthwhile'.
The particular project that I 'braved' with no windows pagefile was an edit of footage of interviews with ageing WWII veterans, to preserve their stories. Would you consider that worthwhile?
I will admit I was in the wrong here. There is certainly some significance in such work and I may have assumed too harshly.
However, I do not agree with how you went about doing it because your work is less relevant than it could have been in today's world to be honest. Why? Because media consumption habits have changed and it is apparent based off your description that you're just doing editing of footage instead of making searchable interactive content (and if you you were not in a position to make those choices and wanted to make them, that sucks).
Don't be offended, I find being direct and challenging is a much better approach to livening up discussions and getting a understanding of people's positions quickly.
What part of the spectrum are you on?
2 meters usually.