CMakeBackwardCompatibilityCXX: Add intro code blocks

This is mainly a sync with other CMake modules for consistency:
- Added intro code blocks showing how to include the modules.
- Adjusted examples sections.
- Added "See Also" sections.
5 files changed