as for the controller running hot i have a thread on here with pics showing a modified heatsink on the controller which keeps temps in line. avalon seems to be afraid of 15k drives. there is no need to fear them if you know how to tame the beasts. microserver can be modded very easily, bigger fan and 300w psu are easy additions, just check the homeservershow forums plenty of people modding away.
also ssd's are not cheap. point me in the direction of a 600gb ssd for 12quid second hand and im all over it.
The problem is you've focused on initial purchase price and totally ignored the TCO. As you seem interested, I played with 7.5/10/15K drives for years on SCSI, same on SAS and even the WD Raptors, same with SAS controllers, flashing them to IT mode and dealing with improving the cooling and running large SAS/SATA pools. I ran 7 drive N36L/N40 mods from very early on and was one of the first to convert them to external SAS cages, I own four of them (N36L, N40L, 2x N54L) and am reasonably familiar with what you can do with them modification wise. Times change, since I got my hands on my first 64GB SSD 15K SAS was dead to me. Now back to your example, you're right that the initial up-front cost does favour SAS, but the ongoing cost is the opposite and that's why people do silly things like buy 'cheap' ex server hardware, I used to run a business next-door to an IT recycling place, they would generally give me whatever I wanted from the old gen stuff as it usually cost them more to separate the metal/shielding than they got out of it and no sane person would pay actual money for it as a server/workstation.
I paid £149 for a 2TB NVMe drive, it's max power draw is 4w, down to 4mW, you'd pay £48 for 4x600GB giving 2.4TB, clearly you win.... until you use your drives. My power unit cost is 13.06p/KWh, based on a quick google the estimated power usage for 4xSAS 15K drives is 65-77w (idle/load), for simplicity lets go in the middle and call it 71w
Y1: £48 (drives) + £81.22 (power) = £129.22
Y2: Y1 + £81.22 (power) = £210.44
Y3: Y2 + £81.22 (power) = £291.66
Now do you see why they are £12? It's because it's better than having to pay to recycle them.
SSD looks like this (i'll use 4w as frankly it's already a one sided argument)
Y1: 149 (drive) + £4.57 (power) = £153.57 (£24.35 more expensive)
Y2: Y1 + £4.57 (power) = £158.14 (£52.30 saving)
Y3: Y2 + £4.57 (power) = £162.71 (128.95 saving)
So, you pay £24.35 more in Y1 for an NVMe SSD, but get better massively better performance and realistically the power figure I used is probably twice what it should be for the NVMe, by the time you've got to the end of Y2 SAS is more expensive and by Y3 is just an embarrassment. If you happen to be deaf and your heating is broken then I suppose you could argue they are less awful, but that's pretty niche. Obviously if you sourced a used SATA SSD you'd likely pay less and it'd be a win for SSD in Y1.
Also as to your point about NAND wear, please educate me - I have SSD based boxes doing 15TB of writes per day for several years, what exactly is it that you think i'm not aware of? The key is to use the correct type of NAND and to make sure that the wear is spread appropriately eg i'm not writing 15TB/day to a 64GB QLC SSD, that would be silly.