Transistor is fantastic even though I had to try it a few separate times to really get into it.

Pyre has super strong aesthetics, but I never really got into it.

In any case, Hades can definitely stand on its own even if you never play the others. Supergiant is worth supporting, but you don't need to do it in order