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 alread

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.