I will forever wonder why 8-bit computers of the 80s didn't have more powerful video hardware. It's not that the technology wasn't available, since most arcade machines at the time had a lot more powerful graphics hardware than 8-bit home machines. (I will also forever wonder why Sega's 16-bit console didn't have hardware sprite scaling and rotation, since that was the main attraction of Sega games at the time...) I…
Later machines had more bandwidth and more complicated memory systems, but the limitations are still the same. You have a fixed number of bytes you can fetch from RAM per second, the TV scans out at a certain rate, and that's going to limit what you can do.