Well, you will obviously need MPEG-1/2 codecs to play any VCDs/SVCDs you make

As far as AVIs go, you'll need DivX, Huffy and maybe MJPEG. There are other AVI codecs, but my limited experience with AVI files is that the other codecs are rarely used and you're not likely to encounter them.