If these are just casual photos of family and friends and stuff like that, then using a camera phone is perfectly fine. If you want to take professional-looking photos then you need to use some sort of camera that can take HD pictures. IMO. I personally won't use or pay much mind to any photos that aren't either in HD or close to it. But there are SO many instances and circumstances, so it's hard to give a straight answer to the question. So basically, casual or fun photos = cameraphone, something you want to look professional = high-end camera
Footnote: I'm really low-tech so I don't know how advanced cameraphones are nowadays, I use a camera from my early 2009 phone and the picture quality isn't that good. Ghetto. Also the lighting absolutely sucks.