Hey everyone,
Thanks for your contribution to this thread in trying to solve this issue! I did some more research and it turns out the damn xbox controller is the culprit :p There are a couple simmers out there complaining about the same camera snapping back behind the tail problem, and they've all been using xbox controllers.
I guess I just need to get myself another controller and then give it a shot! :)