My sister has a very nice Sony digital camera that has video capabilities. She got it for about $300 last year, and it came with a 64MB memory card. I think you can upgrade to 128MB instead for about $15. I have taken some very nice pictures with that camera. I will get back to you with the model number.
Tim