My new cheap PC dedicated to testing Qubes OS and Windows 11 has these useless RGB lights on the RAM. The nice guy at the computer shop who built the PC explained that the "gaming RAM" was the one he has the best experience with regarding reliability. It didn't cost more, the case has no window and I don't see the rubbish.
More problematic is finding a good case with 5.25" bays for optical drives.
It looks like there are two kinds of casings and PCs left: Cheap, tiny office desktop computers and >10000€ swank PCs doubling as disco light. Maybe I'm forced to go in to the direction of server hardware. 1TB of ECC RAM, multiple slots for M.2 SSDs, 10GB/s Ethernet, Threadripper CPU. That will be equally expensive as gaming nonsense, but at least it is useful.
About 2027/2028 it will be time to replace my main computer (which cost about 2000€ in 2017 also counting some upgrades in the following years).
Given some people pay >1000€ for a smartphone every year that is not too much money.