1. turn on the 590, Sony N460 blu-ray player, and Sony HDTV
Yes, create an activitiy which will turn on everything and change them to the right inputs
2. turn on the 590, Time Warner SA8300HD cable box, and Sony HDTV
Yes, same as above
3. turn on the blu-ray player and Sony HDTV using the 590 passthrough feature
Yes, same as answer 1
4. turn on the cable box and Sony HDTV using the 590 passthrough feature
Yes, you guessed it by now
But I would suggest you avoid using the pass through feature unless you absolutely need it because HDMI pass through consumes power even when in standby. You know, save the planet and all that good stuff
I am running optical cable from my satellite box to the AVR, and connecting the Sat box to Tv using HDMI. So when I watch news or something similar, the AVR is not switched on. But when watching a movie on cable, then the AVR kicks in and sound is output on the speakers.
Pretty easy to configure on the Harmony.