Hello LazyMasterGamer,
thanks for that suggestion - a (dirty) workaround for you could be rendering the Camera Path twice - once with Cubic and once with Linear Interpolation. Then, in your video editing software, combine the two videos, using the linear interpolation video when the camera should stand still between the two Position Keyframes.
You can read more about toggling interpolation in the docs.