But I would guess the sheer inventiveness & range of things people put the C64 to was/is astonishing, even to the wildest thinker on the development team.
Complete side note: The brain is a very strange thing. I read this post earlier and then started to so some work. I repeatedly found myself trying to type a double quote using SHIFT-2, which is the key combo for the PET and C64 (my first computers). Actually on the PET, it's not the 2 key, but the key where the 2 would be on a modern keyboard.
Weird the way 30+ year old muscle memory is invoked.
Sometimes it did not. We look back, and some machines were almost there, like the Apple GS. Still great, but with just a bit more thought, could have been amazing.
Many of the better effects on C64, and other computers, were actually exploits. Bugs in the logic were found, then abused, then perfected.
Most of the better titles on the old 2600 (VCS), for example, exceeded engineering specs. A bit of flexibility left in turned out to make all the difference in the world.
Older machines used a combination of software and hardware. That combination turns out to be quite potent over time as people continue to explore what may be possible.
Some have coaxed better color, interlaced video, and more out of a C64, despite that not being intended.
The memory map options were likely flexible, "just in case", and where that was the thinking back then, it often became the max potential case.
Makes me wonder what undiscovered things are possible with say, a SPARCStation 1+, or an Indigo2 R10000 when bit-banging the hardware directly.
Having the memory banks swappable has all kinds of fun quirks. For example, although the VIC-II could address many different 8K memory locations for the hi-res screen, only four are okay, because others would be the character ROM ($1000 and $9000). Therefore, people tend to put the music code at $1000.
Also there's only one color memory for all the character mode pages and character memory is the color memory for hires mode!
I had no idea the fun 8 bit, and older machines would still see development and innovation.
Makes me happy, and I know there is fun to be had when I get old.