Based on those screenshots it sure looks to me like the idea that PC-FX video is in any way better than PS1 video has been disproven, and that includes games released on both PC-FX and PS1.
Similarly, the Super Famicom was poorly supported for the first three years of its life (late '87 to late '90).
There's a difference between a time when a system is actually available, and a time before its release, you know... :p
If you look at each console's life span, the length of time they were heavily supported is remarkably similar, with the PCE actually being supported for longer (90% of its library over six years vs. five years for the SF).
That is somewhat true, but if you separate teh console and the addon, it goes like this:
Japan support lengths only.
SNES - 10 years (12/1990 - 12/2000)
SNES breakdown: Last normal cartridge release 1/2000; last NP release 12/2000
SNES Satellaview - 5 years (4/1995 - 6/2000, but new broadcasts only ran until 3/1999; after that it was only reruns)
Genesis - 7 1/4 years (7 years first party) (10/1988 - 12/1995 (1st) / 3/1996 (3rd, unless I'm missing something which I could be)
Sega CD - 4 1/6 years (4 years first party) (12/1991 - 12/1995 (1st) / 2/1996 (3rd))
32X - 10 months (12/1994 - 10/1995)
TG16 - 7 years (12/1987 - 12/1994, but only two releases in '94)
TCD - 8 years 4 months, plus one more game 2 years 2 months later (12/1988 to 4/1997, plus one more game in 6/1999)
TCD breakdown: regular CD games released between 12/1988 - 5/1993 (unless there's something later I'm not seeing) so 4 years 5 months
Super CD support: 10/1991 - 4/1997 (& 6/1999) so 6 years 6 months plus one more game 2 years 2 months later
Arcade CD support: 3/1994 - 12/1996 (with the 12/1996 game being the only 1996 release that supported the Arcade Card) so 1 year 9 months of regular support with 1 more game a year later
The SNES was supported for the longest amount of time. Turbo CD is second (or technically first including Dead of the Brain, but that's got a big asterisk of "over two years after the previous release"), and the Genesis third.
An unfulfilled place? If you look at what was released after '96, there's a couple goodies in '97 but nothing great in '98 or '99.
Sure, there were fewer in '97 to '00 than before, but the system was getting old by that point and newer systems were out, so you expect it. Nintendo kept supporting the system anyway, though, maybe because of how the N64 wasn't doing well in Japan. Of course though, continuing to release major SNES games can't have helped convince people to get N64s...
As for games, many of the major SNES games from '96 to '98 are on the Satellaview, and in the later '90s many were on Nintendo Power service cartridges as well -- that is, the rewritable carts people could buy and get games written on in store kiosks. Pretty cool idea; it's too bad that they didn't continue it with the N64 and bring them out in the US as well, I think it could have been interesting. By releasing stuff on Satellaview of NP they saved a lot in production costs, much like digital-download-only games. Some games released on Satellaview or NP in '97 to '00 include Sutte Hakkun, the eight volumes of Picross NP, the BS Zelda games, Shubibinman Zero (BS), the eight Picross NP volumes, Metal Slader Glory: Director's Cut, Wrecking Crew '98, Power Lode Runner, and Fire Emblem: Thracia 776. Some also had normal cartridge releases later, including FE: Thracia 776, Wrecking Crew '98, and Sutte Hakkun, but others didn't. There were also a couple of normal cart-only releases in '97 and '98, such as Kirby's Dream Land 3 and Kirby no Kirakira Kids (Kirby's Star Stacker SNES version)... those are mostly quality titles, regardless of what their budgets were. Thracia 776 was the last major release from Nintendo (NP service in '99, cartridge release in '00), but after that they had some more Picross NP volumes and, last, Metal Slader Glory: Director's Cut (released preloaded on an NP cartridge), a remake of a Famicom adventure game.
Third parties had some games too, particularly in '96 through '98; after that it mostly dries up, yes. But in '97 and '98 you do have a few third-party titles worth mentioning, such as Shubibinman Zero (Satellaview only release), Rockman & Forte, Super Bomberman 5, and some more. I guess your response is that the SNES released later, so it makes sense that it was supported longer; really though, it's because it won, not because it released later. I mean, the Xbox and Gamecube released well after the PS2, but they obviously weren't supportd as long!
The original system should've been a Duo-RX with built-in Arcade Card, built-in tap, SGX hardware, and cost $1000. Woulda been a sure winner!
Have you already forgotten that the Sega CD, which released only three months after the Super System Card, has three times more RAM than the Super System Card does? Get closer to Sega in RAM in '91 and they'd have had plenty for the generation.