SYG is a misnomer because most of the states with Castle or SYG never had a must flee law beforehand. It also allows for an active attack in the event of a third party being attacked. That isn't stand your ground.
When it comes to courtrooms, schools, town hall meetings and the like you would be surprised how few LE types are present and most of those who are present have prisoner escort duties to perform. if you search courtroom shooting you will find quite a few.
HOWEVER the issue isn't NEED for the firearm, my state has a shall issue statute not a show need one. It doesn't matter the need but the right. One could argue ANYPLACE a semi to barely trained pistolero draws and starts shooting he/she is more likely to shoot everyone but the bad guy!
The point I am trying to make is those who wrote the more assertive carry laws and use of deadly force made sure they placed a prohibition zone around themselves, but quite content to have the concealed carry people wandering about the 'common' citizen.