Doc: Add CLI examples for non-trivial arguments

[dbaston]

Feature description

Many GDAL CLI options lack examples. Ideally, each non-trivial option could link to a corresponding example of its usage.

Additional context

Examples can either be hard-coded (.. code-block:: console) or dynamic (.. command-output::).

We may want to add functionality to the ..example directive so that we can link to examples on different documents.