Within the range, I would give:
SNES: 10/10 (my favourite game graphics of all time. e.g. FF6)
N64:6/10 (1st party games have good art direction)
PS1: 5/10 (could be lower, but saved by games with pre-rendered backgrounds)
PS2: 7/10 (some outstanding graphics such as Shadow of the Colossus)
Not always. Did you know that Final Fantasy VI had a mobile version with much higher resolution graphics? SquareEnix took it down and released the pixel remaster instead, which matches the original low-resolution graphics closely.
That's just one of the many examples when "better graphics" isn't always better.
I care about art direction. Graphical capability can give digital artists more freedom especially for photorealistic styles. But few games actually make good use of such artistic freedom.
My favourite 3D game graphics is Super Mario Galaxy. Other than that I mostly prefer game graphics from 16-bit consoles.
Prompt: A fantastical photo featuring a unique and whimsical hybrid creature. The creature has the head of a fluffy pomeranian, with bright, curious eyes and a playful expression. It has the powerful wings of an eagle, spread wide and ready to soar. The creature's tail is that of a sleek and agile cat, gracefully curling behind it. The overall atmosphere of the image is enchanting and surreal, with a hint of magical realism., photo (Ideogram)
That's more like fusilli or rotini.