

The video even shows it makes a difference, although it only touches on that part, with no in-depth analysis. Some modern games don’t work properly on HDDs and you get tons of glitches and pop-in.
In older games it probably won’t affect much more than load times though.

As I said, the video is about general types of SSDs, not specific games. It’s also mixed between first load after launch, reload of a save and sometimes fast travel, no real methodology.
When the game uses DirectStorage, a PCIe SSD will be a lot faster than SATA or HDDs. Games like Last of Us Part 2, Spider-Man 2 or Ratchet & Clank were shown. Indiana Jones doesn’t use DirectStorage, but still shows this kind of behavior.
Without DirectStorage, it mostly doesn’t matter, as long as it’s an SSD, although PCIe drives were almost always faster. If you reload a save, a lot of time, it often also doesn’t matter if you use an HDD, although you might still get the glitches and pop-ins from slow asset streaming.
Here’s a list of Steam games, that use DirectStorage. It’s not a lot right now, so you definitely don’t need to switch right this second, especially if you already have a SATA SSD, and you’re not playing the latest AAA games constantly. It is something to keep in mind, when you’re upgrading though.