All similiar based sensors will behave more or less the same, the only difference is with the in-camera processing (ie:built in software) that deals with the noise and colour problems.
In summary,
- all CCD based cameras will suffer badly from noise and it is very hard to push the ISO up without visible noise. However, they are have good reponse to light and is very easy to work with.
- SuperCCD made a variation to the CCD sensor by rearranging the sensor pattern is is able to achieve very high ISO (ISO6400 for a P&S) at significantly lesser noise
- CMOS based have lower power consumption and therefore are less hot and also result in a sensor that produces lesser noise. However, in general, they produce lower contrast pictures (think web cam) but Canon has modified the receptors in a way to overcome this problem and is the (only?) exception to a good CMOS sensor.
- Forveon (not sure how it's spelt) gets rid of the bayer pattern fliter and each light receptor is able to collect light for all 3 primary colours (RGB). Being so, each receptor can now be made bigger and more details can be recorded. Whereas in all other sensors with bayer patterns, usually 4 pixels (RGGB) are used to create 1 pixel on the output photo.
Also, generally speaking, bigger sensor size means bigger light receptor sites which will give lower noise and better dynamic range but with the pixel race going on, bigger sensors are now occupied by MORE pixel sites.. which means the size of each receptor is will also be smaller.