MIPS and SPARC were always a little weak versus contemporaries, if SGI had forestalled a bit with the R18k that would have been enough time to read the tea leaves and jump to Opteron instead.
PA-RISC and Alpha had big enough captive markets and some legs left that got pulled out too soon. That paradoxically might had led to a healthier Sun that went all in on Opteron.
1) Load/store latency is unpredictable - whenever you get a cache miss (which is unpredictable*), you have to wait for the value to come back from main memory (which is getting longer and longer as CPUs get faster and memory latency roughly stays the same). Statically scheduling around this sort of unpredictable latency is extremely difficult; you're better off doing it on the fly.
2) Modern algorithms for branch prediction and speculative execution are dynamic. They can make observations like "this branch has been taken 15/16 of the last times we've hit it, we'll predict it's taken the next time" which are potentially workload-dependent. Compile-time optimization can't do that.
*: if you could reliably predict when the cache would miss, you'd use that to make a better cache replacement algorithm
That is kind of how it worked more than 30 years ago (pre 1995), but not since, at least in OoO CPUs.
In fact it was found that having more than a 2-bit saturating counter doesn't help, because when the situation changes it takes too many bad predictions in a row to get to predictions that, actually, this branch is not being taken any more.
What both the Pentium Pro and PowerPC 604 (the first OoO designs in each family) had was a global history of how you GOT TO the current branch. The Pentium Pro had 4 bits of taken/not taken history for the last four conditional branches and this was used to decide which 2-bit counter to use for a given branch instruction. The PowerPC 604 used 6 bits of history. The Pentium Pro algorithm for combing the branch address with the history (XOR them!) is called "gshare". The PPC604 did something a little bit different but I'm not sure what. By the PPC750 Motorola was using basically the same gshare algorithm as Intel.
There are newer and better algorithms today -- exactly what is somewhat secret in leading edge CPUs -- but gshare is simple and is common in low end in-order and small OoO CPUs to this day. The Berkeley BOOM core uses a 13 bit branch history. I think early SiFive in-order cores such as the E31 and U54 used 10 bits.
They are used in a lot of DSP chips too, where you (hopefully) have very simple branching if any and nice data access patterns.
I did tech support for DEC's Starion line of Windows PCs. I'd get the occasional call from someone wanting help with a VAX or a Rainbow or some other piece of DEC kit. But a lot of DEC's customer support was actually handled by 3rd party companies, including the one I worked for, and we had no way of connecting people to anyone from DEC itself.
Compaq killed off most of the online resources for DEC equipment fairly quickly. I always thought DEC deserved a better death... But at least it was better than being bought by Oracle.
I had a DPX/20, which was for that model just a rebadged Microchannel IBM RS/6000. I was 12 and trying to figure out how to use it. I knew what I was in for, that I needed to load AIX, but the "firmware" on these are bare bones and you don't have much to go on once it passes off control if you don't know if your console is working in the first place.
Given what I now know, they were surprisingly kind and passed the call around until landing it with an old timer that was familiar with the model and somewhat bemused that I had it and was trying to use it but didn't really know how to help me remotely.
Eventually someone on Usenet clued me in that I needed more pins on my serial cable connected, and it all turned out to be a nice learning opportunity building the GNU toolchain and AMP stack on it.
There was some serendipity years later when I moved back to Phoenix after school and joined a newly formed PostgreSQL user group. Bull was trying to pivot into that open DB market and still had a huge campus in Phoenix where they held the meetings. It seemed sparsely occupied and the writing was on the wall that was all going away (it eventually did a handful of years ago), but I was still a bit wide eyed now having some notion of the campus's historical significance as Honeywell, in the Multics project, and other things. And that my naive call from back then was almost certainly answered in that facility not that far from where I was struggling.
I'm on a bunch of retrocomputing discords where youth still find obscure old systems, typically Sun, SGI and the parallel universe IBM systems (mainframes and as/400 line), and manage to figure them out.