I was mildly curious, so I took a look around what DSD128+ material is available for purchase to download, and I can honestly say there's currently no releases in DSD128, DSD256, etc. that would be personally appealing. In fact, all the "worthwhile" DSD content, in my opinion (and that I'm interested in), still comes from SACDs (which is DSD64). There does appear to be some classical DSD128/DSD256 releases, which I may have to check out at some point out of curiosity, but I imagine I wouldn't hear any difference from PCM or DSD64.
I imagine the attitude towards DSD1024 here would be different if there was content actively being released for it, major releases and whatnot. And more (affordable) DACs adding support for it but even then it just seems to me like higher rate DSD is way beyond diminishing returns at this point. And honestly I feel the same way about PCM past 192 kHz, which I never see downloads for on sites like HDTracks or Qobuz.