Thanks for everyones suggestions.

I used houkah's suggestion. I grouped the camera to a box and added the box to the motion path. This allowed me to have total control over the camera's aim as the camera followed the path.

I'm currently rendering the vid. When its done I will post it.

Thanks everyone.