Your best bet would be to have a look through the forum on
www.ukpassats.co.uk (you need to sign up to view thread replies, but it's free) and also the Skoda Superb Mk1 forum on
www.briskoda.netLots of CCM information on there; the problems are almost always caused by water leaks through the pollen filter and/or door window regulator carrier plates. The wiring under the carpet has lots of joints which corrode in the wet, and the CCM can get water in it too, giving rise to the kind of problems you have described.
Another issue, microswitches in the door locks go faulty and need replacing, again info on those forums, and lots on youtube too.
It's all fixable, just needs a bit of patience.