Maybe look into a Pentium 4 for your processor, if you're not into the games so much. See this one
If you want to do major video/photo editing, I would suggest more than 1 GB of RAM. Go for 2, and look into DDR2 RAM.
If you want a lot of storage, I would suggest a RAID setup with two of these drives
For an optical drive (aka CD drive), you'll probably want a DVD burner if you're going to be doing movie work. They're cheap nowadays, under $100, and usually under $50. I can remember when a plain CD-RW drive was an amazing technological innovation... but I digress.
is a very stylish and very affordable case on Newegg.
Be sure to remove the included power supply from the case, get an Antec, probably around 450W.
Edit: Also, I agree with Macdude in his videocard selection. A 6600GT is a great value, and plenty powerful.