As for 2009 up to whenever Scott left I've never actually watched any of those performances because I know it wasn't the best for live shows. His voice just wasn't doing that well.
Oh you're not missing out on anything trust me... I was very fortunate to see them live for the first time in 2002. That was one of the better shows I've ever been to in my life. Weiland was ON, his voice was great, he was every bit the stage god that he's hyped up to be. The songs were played at great tempos. They were so on top of their game.
I saw them next in 2008, 2009, 2010 (the show they released on dvd), 2011, and 2012. In my opinion NONE of those shows ever even came close in quality to when I saw them in 2002. The band was always super late in starting, played okay musically, some technical troubles here and there which I can't dock them for; but Weiland was always disappointing. He just always kind of stood there. He didn't move like he used to, he didn't command the crowd like he used to, and his voice sounded weak, old, and weathered. Something was always just lacking with the energy and a lot of it had to do with tempo. The worst of those shows was in Rockford in 2011. The songs were played SO slow and it was so bad that I really was tempted to just accept that I wasted $70 on a ticket and make the drive back to Chicago early. I did end up making it through the whole set, but it was memorable only for the sense of how bad they were and how disappointed I was. When you've seen first hand how good this band actually is, and what their potential is then you definitely know when they aren't living up to it.
Also I wanted to say that I totally agree with what you said about Sex Type Thing unplugged. Although that was more than just tempo, it was a totally different approach to the song overall. Great vision on their part!