Transform co-ordinates overwriting each other when the camera rotates?

I'm sure this has been answered before and I've found mentions here and there of this problem but I can get my camera to move absolutely fine with transform.Translate however when I try to add transform.Rotate in the mix the camera actually tilts rather than rotates. Could someone explain to me the mechanics of why this is? I'm trying to wrap my head around it and the solution, supposedly using EulerAngles fixes it but I'm still researching all of this.

Oh yes! Sorry, I had gone and forgotten the correct term, I'm getting gimbal lock.

 

I think I found the solution, possibly overthinking things there

https://docs.unity3d.com/ScriptReference/Transform-eulerAngles.html