The reverse of this, I've heard anecdotally that SCBA can be used for water rescue down to a depth of 15 feet in an emergency. I remember reading about a kid stuck in a flooded storm drain the rescued on SCBA because it was all they had.
I have pool dived with multiple brands of SCBA.
Back in the day when you could have switched demand mode, you just needed to flip it to positive pressure. I don't really recall any of them free flowing.
As for using a rebreather…I am not so sure that they can be used for but a short time above water.
It depends. There are rebreathers designed for surface work. They have a component in some of them that you put a frozen device in. Others I have seen (for oil rig or industrial escape) I guess it just gets hot. Only good for 10 minutes or so though.
A couple of points here;
Contaminated ambient air is not your only hazard in a fire. You could very easily get burned. I have been in fires where it was uncomfortably acceptable laying on the floor, but just a couple of feet up it was melting the plastic items on the shelves.
Where you might otherwise be more conservative in your behavior, you may be lulled into remaining too long or taking other risks because you believe you have a patent source of air.
The second issue is hazmat / wmd events. I am very surprised at the multiple chlorine discussions. When airborne chlorine contacts the moisture in the air it forms an acid. I have seen releases; it peels the paint off the walls, ruins concrete and kills plants and animals.
If you don't have any skin protection, you're probably not going to make it. Dermal exposure, especially with broken skin, is listed for pretty much every threat agent and toxic product out there. It is, after all, your largest organ.
I do not have SCBA nor SCUBA for home (or, hotel) emergencies. What I do have for my wife and I are escape respirators. Little red box. Inside is a hooded respirator. The hood is fire resistant, so no facial burns, no clip for our noses, no burnt hair. Also is a pair of ove' gloves. I can grab a door handle, manipulate things, and do what I have to do to get my family out, and even perhaps consider helping others or mitigating the situation. (shrugs) I have options.
I do own my own SCBA, a couple of different kits in fact to address a few different mission sets. But I have trained with them, am aware of their limitations, and... it is what it is. I also own a PAPR and about a half dozen air purifying respirators as well. No one golfs with just one club.