Help: Clarify that CMAKE_<LANG>_FLAGS are used when driving linking

State explicitly that these flags are used when driving either compiling
or linking.  For linking, document their order w.r.t. link flags
specified by commands.

Fixes: #24662