I usually use 99% isopropyl, but I have used water without issue as long
as it is given adequate time to dry before using the printer.
I'm glad you didn't have any long term issues with the contact cleaner,
but, as I stated, I have seen drums ruined with the wrong solvents.
As I previously mentioned the cause of white or black spots can be a
defect in the drum, an abrasion cased by mechanical wear, adhesive
contamination, strong light, other mechanical issues which can leave
toner residue, an overheated drum due to heat transfer from the fuser
area causing the toner to fuse on the drum, I have even seen damages
caused by paper jams when the paper is attempted to be removed from the
printer, often from the front end. If you reuse paper that has been used
on one side, and there is glue on it, staples which weren't removed,
etc, that can damage the drum.
Lastly, the drums don't last forever, so in some cases the drum just
wears out. Without seeing your printer and how it is designed it is
difficult to say what may have caused your drum to perform that way.
Art
If you are interested in issues surrounding e-waste,
I invite you to enter the discussion at my blog:
http://e-trashtalk.spaces.live.com/