I haven't seen the Sony Mavica family mentioned yet. I was a public school music teacher who purchased one for my fellow teachers and our students and even the Principal couldn't mess it up.Saves to floppy disk so it can be shared and used a lot. I would get one with Zoom for those non-intrusive close-ups of your friends playing and singing.
They have really fancy ones that also shoot short movies, but I like my oldie.