Can I expect to take this and shoot on auto mode and be ok???
Yes, but it is heavier to carry than your P&S. Also, use the P setting, not the Auto. They are the same but P will not fire the flash if you don't need it.
My favorite parade is spectromagic-----love to get pics of it......the last camera you could put on sport mode and get pretty decent shots for that type camera---------what specifically should I set the S3 to to take shots that are great????
The S3 also has a sport mode. Use it, or you can try the Night scene or Night snapshot modes. The second one is under the Scn menu options. You should try out the two settings to see which work best for you, although there are many other ways to take night scenes.
My other camera had prob with low light and movement----sport mode offers no flash-etc, we will be at the P+P party at night, so alot of low light situations------what to do with the canon????
This will always be a problem. Low light + movement = blur. Use a high ISO (400 or 800), which will allow the apeture to operate more quickly. Note that the pictures will be more grainy using a higher ISO, but at least you will get the memories you want.
Is there a book other than the manual for this camera that will help me out??
Yes.
Click here
But, any good photo book will help. Try Understanding Digital Photography by Bryan Peterson.
I'm getting a little (ok, ALOT) nervous about having a brand new camera and possibly goofing up the family pictures on our trip
This is a great camera and I think you will be suprised by how well your pics come out. If I were you, I'd PRACTICE before you leave on your trip, especially some night scene stuff. This will give you a good idea what you need to be concerned with when your doing it for real.
And, enjoy. That's why we take pictures.