That does take some getting used to, and yes, there is a way to turn it off.  You can turn it off.  It's called 'zoom to cursor' and I believe it's either in the options menu or the key binding menu.  I can't remember exactly which, but I do know it's there.

yea, that frusterates me, too. I love that feature for planets, but for ships it gets annoying. As said, the easier way to turn it off is by clicking the mouse and video camera icon on the top toolbar.

Actually, Zoom to Cursor is not what makes the camera follow. Zoom to cursor only does what it says, and centers the camera on your cursor when zooming. With it off, you have to actually scroll the camera with arrows/edge of screen, which is a lot more cumbersome.

Camera snapping to units is a hidden option in the camera.setting file in your user path (same place mods go, only \Setting instead of \Mods):

zoomToCursorLocksOnMovingEntities TRUE
zoomToCursorSnapsToEntities TRUE

You can change these to get the effect you like.

Welcome

To be honest, what annoys me is that because I use window mode, when I move mouse to switch app, it would go in the direction of my mouse, but managed to turn it off