Assuming you have or are interested in a camera with manual capability - have you wondered WHY you might want to go to manual mode instead of letting the camera decide?
Here's the real deal - automatic modes work great with fairly even light coming from slightly behind you and the tones you're photographing are either middle tones or there's a good distribution of tones.
Tones being white to black and all the levels of grey and colours in between those extremes.
Where auto or program modes start to fail is when you have a mostly white scene - like a white puppy on snow, or being out in fog, which makes a camera think it needs to make the pictures darker and thus white becomes grey. Auto and program modes also have difficulty when the light comes from behind or beside the subject - imagine your child in a white shirt standing in a doorway and the sun is coming from the side (which would be a cool and dramatic picture - what part do you WANT to be exposed right? Do you expose for the bright part of the face or do you expose for the shadow side letting the bright side go completely white?
The other aspect is how much do you want to be in focus? Do you want shallow focus so that just your partner's face is in focus or do you want to have everything in focus? Auto and program modes default to more of the 'everything in focus.'
In the end - are you TAKING a picture, ore are you CREATING a picture? If you want to get really creative you want to create each picture - make it look the way you envision it. That skill takes time and practice - and taking lots of pictures, and doing it in manual so that you have control over each aspect of the image.
However if what you're doing is documenting your life and not worrying about being 'artsy' - then program mode is fine and will do a great job.
As in all of photography - the purpose of the photos determines the methods being used.