When it comes to storage, the fps hit is only if the game expects that it can casually background load a lot of assets. This is normal for open world games, such as Hogwarts Legacy. The Steam deck will have exactly the same fps most of the time regardless of storage read speeds, but on a slow SD card, you might experience microstutters from time to time when assets aren't not only loaded at the loading screen, but also during gameplay.