Can SCUF Instinct turn on my console?

Yes. Just like a normal Xbox Series X|S controller by pressing the Xbox Button.