Your question misunderstands the nature of self defense laws in general, with the stand your ground and castle doctrine just being special cases.
In order to claim self defense, you have to assert that you thought there was a danger, and then that assertion is judged as to whether it was “reasonable” or not. This judgement is initially made by the prosecution as professional judgement whether it is true and/or whether they can get a conviction in the face of such an argument. If they don’t believe you or want a trial anyway, then by a jury.
If you watch a 9 month old baby crawl down the sidewalk, and then up into your house through an open door and then take an axe and kill the baby claiming castle doctrine or stand your ground or any other form of self defense, is going to be utterly useless in all 50 states. The prosecution won’t buy it and neither will the jury.
If on the other hand, a 6 foot 8, 300 pound, body building, martial artist, convicted serial killer escapes from prison, and is discovered asleep on the floor of your living room with a gun in one hand and a knife in the other, and you blast him with a shotgun as soon as you identify him, a claim of self defense may be viable depending on your local laws (and the jury)
Having him awake and standing in the center of the room and it’s going to be viable in even more.
Having him awake and advancing on you, even more.
Having him advance on you while saying he’s going to kill you, and it’s probably a slam dunk in every state, with the prosecution not even bothering to put it to the test, even if you tell the cops you are glad he’s dead and he had it coming.
If your hypothetical house cleaner was caught vacuuming the living room floor, keep your mouth shut and hope you have an inventive and convincing attorney, otherwise you’ll probably be convicted of premeditated murder.
I can’t think of a circumstance where it would be reasonable to kill someone while they were doing nothing more than vacuuming the floor without my personal permission.