One would assume that the same method used in other games, to get the camera to auto-close in on your character, could be achieved similarly in STO.
If i'm standing in a corridor, rotate my camera, and the "camera" hits the wall, it will automatically zoom in tighter towards the character, instead of clipping straight through a wall. Once the camera is no longer obstructed by the wall, the camera automatically pans out again.
Why does this not work for starships as well? If you rotate the camera towards a point that "could cause" clipping, have the camera instead zoom out a bit. So that people who WANT to see things up close (without clipping) can still do so.