I hear you too, @whitemirrors, I fail to see what other posters don't get about your situation and just because they don't get it there is no need for them to be so nasty.
Your home should be a place where you can relax, stick your knickers on your head and belt out Bohemian Rhapsody if you want, where you can have peace and solitude if you want, where it is a distinct and separate environment from where you work and hence different rules and expectations. Turning your home into an extension of your office or workplace changes all that and it doesn't matter where in the home the person is working, the dynamics of the home are changed, you have to behave differently, the person working behaves differently, you are wary of being heard or seen, along with a raft of other adjustments you have to make, you hear and are privy to work conversations, the home is no longer just a home.
Having the working person working in the home all the time also changes the dynamic between the people in the home it's totally different to when they are there on days off, when working from home they are there but there in different capacity.
Such fundamental changes can wreck relationships not because the people don't love each other but because of the enforced changes in the way they are having to live and it requires fundamental changes to the relationship to make it work and that is hard and not always achievable.
I completely understand what you say when you said that when your husband worked outside the home you looked forward to him coming home, that, in my book, is a perfectly normal and natural way to be.
I feel for you OP, it's not a nice place to be especially when there doesn't seem to be a solution on the horizon. I hope things do change and improve in the future for you, you are not wrong to feel the way you do.