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.

This is how every iGPU and embedded SoC with a GPU work. It’s not exotic or something that games need to be specially coded to handle.