Score another way to shock Joan on waking up.
I find it hard to believe he could've assembled all that in her room -- including a whole wall of clippings right behind her head -- without disturbing her physically or making enough noise to wake her up.
I figured out very early that the shooting was staged in a fake room. Right in that first scene where Sherlock was reviewing the footage in the media room and discussing the impossibility of anyone getting into the office undetected, I thought about the fact that they were relying on a video to establish location and realized that someone could've faked the video. But I didn't figure out the rest.
I'm a little disappointed this ended up going the obligatory murder route. It would've been fun to see Sherlock pull off the heist. At least they could've waited until after the heist to bring in the murder angle.
I'm glad they brought back Fiona, though I think maybe they're advancing the romance a bit too quickly. This show has always been good about inclusion of diverse types of people (though we haven't seen Miss Hudson in ages), and it's interesting to see them work with a neuro-atypical character. It might've been nice to see more of Sherlock and Fiona bonding intellectually and solving problems together before the romance grew. She could've become one of his Irregulars and been included in the stories that way.