I'd encourage anyone interested to download VICE and try putting a sprite in the sideborder yourself. It's quite satisfying to see it working!
CBMPrgStudio is a solid free windows app. I like cross-platform WinVICE for it's great monitor.
Once you get to be an expert, people seem to use C++ to synthesize their own 6502 routines.
I recently got a cheap as chips 1541, now I just need to get ahold of my C64-C that stuck in my mother's garage about 1500 miles away!
I know my way around Amiga demo programming, but would love to have a go at C64 too.