If you want something with a small footprint I would personally go for Rust, but anything that compiles to a static binary is going to be better than something that needs a dedicated runtime.
Python is what I use for small one-time scripts and utility stuff that doesn’t need to run long, but it may be worse than Java…
I’ve selected “performance” in the PS5 settings, but I’ve experienced several AAA games ignoring it and having their own graphics setting that defaults to “fancy graphics” mode.
3/4 of players want performance, but publishers don’t care.