RAM size on consoles: How did they make those old awesome games?

Of course we know that consoles have little RAM sizes n stuff, even until PS3 with 512MB
The Atari 2600 had a ridiculous amount of 128 bytes.
NES had 2KB
SNES hab 128kb+

I dont really know what they did on SNES in term of programming language but I think it was already C at this point, whereas ATARI was definitely assembler and NES mostly assembler if I’m correct.

and then you have especially the PSone with 2MB system Ram and 1 MB GPU RAM…
How would you even get all that great shit in the RAM and onto the screen with those limitations ? textures and everything…

Are there like in depth interviews or documentation on how coding in the pre PS2 area was done ? =D