I put the below code in a local script in the starter characterScripts and It works.
game.Workspace.CurrentCamera.CameraSubject = Workspace.Part
this causes you to look at "Part" whenever you join the game. However, The version of the script I want is this:
wait (1) game.Workspace.CurrentCamera.CameraSubject = Workspace.Part
For some reason the wait command makes the script not work!!! I'm really confused and need help.

2 comments
It does work for me.
Hmmmm... the part's Parent is changed from a folder to the workspace, but it does not give an error or anything and the change is during the "wait (1)" your script is slightly different than mine so I'll try the "waitforchild" command.