An upgrade card with a 20Mhz 65816 and 16MB RAM was actually sold as a product: https://en.wikipedia.org/wiki/SuperCPU, but it didn't really make anyone happy. The C64 purists stuck with the 6510 and those looking for more power just switched to modern architectures.