FindMPI: Add NVHPC compiler support
!5475 (merged) introduces support for the NVHPC compilers, discussed in #20887 (closed).
During review of the merge requests, some changes to FindMPI were proposed but dropped in favor of further discussion. We can hold that here.