Shared memory between CPU and GPU isn't exclusive to consoles. All (?) integrated GPUs do it. Mobile devices, PCs, Apple Silicon, it's all the same.
The only big difference is consoles have the CPU using GDDR memory (what dedicated GPUs use) instead of typical DDR. You're not going to need to code anything differently for that but it will have different performance characteristics.
I think you very much want to code differently if you were to target gddr instead of ddr. Unless you were only working at a high-level of course, but it would significantly influence eg the rendering engine
Is it something wihch would make PS5 attractive to run local LLM models? I've heard Mac Mini shared CPU/GPU memory makes it popular for that.