Check the latest video from Linus Tech tips on Youtube, they did a deep-dive into the non working modern sleep on Windows.

The conclusion was, as you've already tried, change sleep setting in bios to "Linux-mode", or just get a mac.