I do not know this board, and I am no computer expert, but I can make a couple of guesses as to what is happening (and I am guessing!). When a computer starts up, compatibility is everything. Any piece of hardware is not understood by an operating system without loading a driver it will not work until that driver is loaded. That is fine for things like scanners, sound cards and the like that aren't needed to get the operating system running. However, any device that is required for the machine to boot MUST be accessible without a driver, i.e. it has to be directly understood by the kernel. Since it is impossible for a kernel to support huge ranges of hardware without becoming excessively large and vulnerable to attack, the simplest way to ensure compatibility is to run the hardware in a default mode the kernel understands until the drivers are loaded, at which point it switches to its high performance mode. With USB this means running the hardware at the basic level (1.1 or even 1.0) and the boot drive in IDE mode. This would fit with what you are seeing. This certainly would explain the USB behaviour, and covers most of your AHCI issues too. If a DVD drive is set to AHCI mode it cannot be seen by an operating system until the AHCI drivers are loaded. The 20 second pause during windows booting would be the drive switching from IDE to AHCI mode. Also, the newer drivers are probably designed to make the switch more quickly, and when coming out of sleep mode the drives will be in IDE mode when powering up, then switch to AHCI mode once the operating systems begins running, accounting for the delay.
It is also worth bearing in mind the problem may not be entirely down to the motherboard. The hard drives may not be good at switching modes and the drivers may be less than perfect. That said, as a first step I would suggest ensuring your have the latest BIOS for your board installed, ou have the latest drivers for your operating system, and you check your hard drives do not have any known issues or need BIOS updates. Only once everything is fully up to date should you start looking at or for board faults, and if you get to that stage the first thing to do is contact Gigabyte technical support for assistance. They may know about these issues and know how to get rid of them.