Personally, the SNES is my #1 system ever, with the NES a very, very close second. So many games I'd consider all-time favorites were on the SNES. I was enthralled with the system when I first saw it. Maybe not to the extent of how I felt when I first saw the NES several years earlier, but still. And that sound chip was just amazing.
But back in the 90s, PlayStation was to me just "that system that Final Fantasy is on now." Teenage me honestly had no interest in the PS1 when it was new. FF7 released exclusively for the system is the only reason I even bothered buying one, and I never owned that many games for it. A big problem I had with it was a broader problem I had with a great many Gen 5 games, namely the fact that the shift from 2D to 3D presented a lot of challenges for the industry. It was all new to everyone, so everyone had to figure out how exactly to make 3D games with good gameplay, including controls. Most didn't do that successfully. Also, I was not as impressed visually with most early 3D games, which often had problems with terrible frame rates, ugly textures, and iffy models. While Gen 5 had some absolute gems, there were so many games that were not only absolute eyesores even when they were new, but they were just plain difficult to enjoy because they had poor controls.
I personally felt this was a bigger problem on the PS1, where developers were essentially locked in to creating controls for 3D games on a gamepad that was basically a modified SNES gamepad, which was designed with 2D games in mind. The N64's controller showed Nintendo was aware that fundamentally new types of gameplay required a rethink of controls, including the need for an analog stick being there by default. Super Mario 64 was a game with solid gameplay, and it's clear that everything about the controller was built around that. The controls were immediately intuitive. I press the stick in a direction, and Mario moves in that direction. The camera was solid for its time. It also had simple and cartoon-like visuals that gelled well with the primitive 3D graphics capability of its parent system. But even then, there were still a lot of N64 games with terrible controls (most of them third-party).
My perception of the PS1 wasn't helped by the fact that I didn't get one until 1998 after getting my first job, at which point I already had spent many hours over the course of almost two years playing N64 games over at a friend's place. I was constantly fumbling with the controls on so many PS1 games. For example, Resident Evil 2 was my intro to the series, and while I toughed it out to the end, I didn't have any interest in further exploring the series because of the clumsy nature of the tank controls (I later got interested in the series with the RE2 remake some 20 years later).
As a matter of fact, because there were so few games in that generation that I really, honestly enjoyed beyond most Nintendo & Rare titles and FF7, I kinda drifted away from gaming towards newer interests around the turn of the century. I still played video games, and Gen 6 also had some great games that I enjoyed (especially Halo CE), but it wasn't until the 360 that I started putting more money into gaming. By that point, the industry had started to standardize controls (left stick moves, right stick looks/moves camera), and the visuals had improved substantially, and the industry had really gotten into the groove of making 3D games. But those early years of the shift to 3D really were that rough for me.