That was a nice little read! It seems the author has a series of these articles on consoles ranging from the NES to the Wii https://copetti.org/projects/consoles/
An excellent overview. That tiny 4 KB RDP texture cache really hurts! It’s a shame since it has perspective correct interpolation and all.
Also the N64 RDRAM runs really hot :)