I live in Cornwall and am upset at the bad press Newquay has been getting. It is a party place but to be honest it has always been that way. In all fairness it is no different to many other similar places in the UK. In the main part it is still a beautiful place but is very touristy - something which is not down to local people. There are many other beautiful places in Cornwall which are very family orientated, my favourite being Perranporth.
I love Cornwall and Newquay is okay during the day, we liked going to the beach and watching the surfers. The town was nice and the ground train was fun to take DD on, we had a nice day there. I wouldn't base ourselves there for a whole holiday though as there is nicer places in cornwall.