A lot depends on what camera generated the file. At one point, you had to download software from Adobe. However, it didn't work for all cameras. Nikon, for example, was playing games by encrypting their raw files. It did work with my Canon. All manufacturers have their own raw format.
CS and CS2 are further along in that respect.