A C64 is a few orders of magnitude less complex than a modern PC; it's sufficiently simple for all the hardware to be comprehended by an individual, yet still powerful enough to do some interesting things with. Although it is a commercial product, it's from a time when details on hardware programming were more freely available and regular users were encouraged to write programs too, which is very empowering. Doing that is a great feeling that makes it seem like you really do own the computer you bought; contrast this with the locked-down, highly complex, and multilevel-abstracted environment of modern computing devices that strictly divides users and "developers", almost making them enemies of each other.
I think the fact that new C64 demos are still being written with impressive new effects, despite the limitations of the hardware, is a great demonstration of how far human creativity can go toward solving problems, as opposed to the "throw more hardware at it" mentality.