I now have a simple USB remote control. Since it's USB, it can wake up the PC from sleep when I press a button on it.

The USB-CEC would basically emulate a keyboard and send keys for the PC accordingly the CEC message the TV sends. If the PC is in sleep, the USB adapter could wake it up.