Well, further adventures with the #OCLP iMac running Sequoia are promising. It's settled down now iCloud indexing has finished (medianalysisd and suggestd were hammering it).

I've installed Lightroom on it; there's a little graphical corruption every now and again, but it disappears after a second or two.