How different bitrate mode works for video encoding and which one should you choose?

In short, CRF should be good enough for most non-streaming use because it doesn't waste bits on easy to compress clips (quality based). Otherwise use a Capped-CRF if a maximum bitrate cap if necessary.