Generally no, I wouldn’t expect weapon mounted NV/thermal to be helpful in the majority of home defense situations, or at least not be more helpful than a high quality daylight optic paired with a high quality weapon light.
One of my highest priorities for a HD weapon is that it always has to be ready without playing with buttons on optics. That means constant on optics like aimpoints, with the occasional exception for something that turns on with motion. NV and especially thermal drain batteries very quickly and usually can’t be left in a constant on state.
When using NV for CQB (which is essentially what you are doing in HD) it is very advantageous to have the NV on your head/helmet. This lets you maintain situational awareness and look at different things without having to point your rifle at absolutely everything to see what is going on. Even if your plan is to hole up and wait for the intruder to come to you, distances are probably going to be close enough that you won’t have a great field of view through the optic and you’ll want to keep it moving.
Depending on what optic you’re looking through, a thermal may or may not give you enough detail to be able to tell exactly who is on the other end of your gun. Granted this is situational - if you live alone, don’t expect anyone to be coming by, it’s 3 AM and they loudly kick your door down and are screaming that they’re going to kill you, facial detail isn’t the most important thing.
Plus the old argument that you have to point your rifle at everything in order to see it. We’ve moved well beyond that being an issue with weapon lights, but it is very much an issue with weapon mounted NV and Thermal. It can be somewhat mitigated by range, but inside a hallway you will have a very narrow field of view. Contrast that to the amount of spill and depth from a good weapon light which will completely light up the area, or at least the person in question so that you can see both who it is and what they are holding in their hands.
Again, I won’t say it couldn’t possibly be useful. If your “bump in the night” scenario is more akin to needing to take out some coyotes that are attacking your livestock, a NV or thermal scope could be useful. But for normal HD I would rank daylight optic with white light first, then helmet mounted NV with IR illuminator/laser, and as a distant 3rd, weapon mounted NV / thermal.
Also, not saying I would plan to use helmet mounted NV for normal home defense either - mostly due to how long it takes to to get it set up. Helmet on - NV on mount - retention attached - focus for both objective and ocular lenses (depending on unit), possibly doubled if you’re using dual tubes… I’m a big fan of night vision (it’s the only super power you can buy!) but I *also* have training in using white light at night, and that’s significantly faster to be ready in what is likely to be a “grab and go” type of scenario.