The Final Fantasy XIV Endwalker Official Benchmark uses actual maps and playable characters to assign a score to your PC and rate its performance including scene loading times.
The benchmark gives an overall load time as well as loading times by scene.
Lexar's NM790 does well enough in the Final Fantasy XIV Endwalker Official Benchmark. It only tops one of the results charts (Scene 2) but it doesn't stray outside of the top 5 of the remaining Scene traces.