Is my understanding correct, that this is not for 3D view of single models (like in CAD applications), but rather geared towards landscape views with high view angles >90° (in games most notably)?
Yes, they are compensating for the distortion produced by wide-angle lenses and if you don't use a wide rendering angle, e.g. in a CAD software, the effect will be minimal.