Avancing while firing
They say in the Military it takes five or six guys advancing on a fixed position for every one soldier defending that fixed position. There is a reason they say that, most of those five or six guys are going to end up wounded or dead.
While there may be some situation where advancing while firing is the best situation for civilians, it is usually only a tactic for heavily armed, with body armour and a team for law enforcement and the military. In most situations I would only move foward to cover and would prefer hitting the dirt firing back and taking whatever cover I could find or moving laterally to the enemy to find cover. Most guys in combat who remained standing or even kneeling were wounded or killed, however if I am upright running left or right of the enemy's position while firing at the enemy while trying to get to cover is certainly better than just standing there blasting away. My combat was without body amour I do not know what the combat SOP for Soldiers with body armour is.
As for room clearing if you can, don't do it. There is an old saying "Never go to a Man, always if you can let a Man come to You, the First Thing the Eye sees is Movement" If you know you have an intruder in the home, collect your family and call 911 and go or stay in a preplanned room where you can provide hopefully hard cover or at least concealment for your family and yourself and go into your preplanned ambush, rather than clear the house and walk into the ambush the intruder sets up for you, let him come to you into the preplanned kill zone of your ambush.
Lastly I love IDPA and I plan on getting into 3Gun, in IDPA you shoot and reload from cover, you learn gun safety and fast and accurate shooting under some stress, however these are games or contests and meant to be fun and advancing is a necessary part of those games or scenarios, however advancing is not part of my game plan, sometimes what is boring or logical or does not seem heroic will actually save your life.