My current 'CCD camera' is the old faithful webcam
It's getting increasingly difficult to squeeze more out of it, but I have learned a lot over the years and think I can put the experience to good use with a modern camera.
I could guide with it but that would require me to invest in a guide scope and a separate guide camera... So rather I have been saving for a bigger camera. I'm getting the QSI 683wsg, nice and compact with integrated off-axis guider.
I'm thinking of building an all-sky camera from the ToUCam once I upgrade. That would be a handy accessory for the observatory.
By the way, I also noticed how transparent the sky was yesterday, it looked awesome. I didn't test my limiting magnitude but around 6.0 would be a good guess.