I often find games with a moderate pace to be the most enjoyable.
If the story is interesting, though, I don't mind the pacing at all!
When the pacing is slow, I sometimes find the game to feel tedious or boring, while faster-paced games can sometimes make it difficult for me to connect with the story or characters. As a result, I often find myself enjoying games with a moderate pace the most.