@Steven198 You come across as a decent, reasonable person. As far as the noise issue, I agree with Andrew- there is some responsibility on the part of a guest to research the location of a listing. If you see it is on a main thoroughfare in a city, you can assume it will be noisy. And whenever a guest has special requirements, such as working from home and needing a relatively quiet place to do so, inquiry messages to the host before committing to a booking are in order, letting them know what your needs are and making sure the listing will be a good choice for you.
Yes, it's a good idea for hosts to mention anything that could be a negative for guests, but it's not always easy to foresee all the things guests could find objectionable. And if the host is used to that level of noise, they might not even really hear it anymore themselves, it just seems normal to them.
We may say something and make assumptions about how the other person takes it. You assume that saying you work from home would automatically tell the host that you require relative quiet. But that might never occur to the host.
It's like when hosts complain that they ask guests to clean up after themselves before checking out but the guest left the garbage bag inside. If a host just gives some generic request, the guest might not have the same concept of what that means as the host does. If the host wants guests to take the garbage out to the dumpster, they need to specify that.
If it's really just a matter of plugging gaps around the window, that's a pretty easy fix. I have no idea what's available in the area, but hardware stores sell weatherstripping that can be stuffed in the gaps, and maybe you could suggest that to the host. Even old rags from strips of cloth can be pushed in with a non-sharp tool.
Regarding the water pressure- am I right in assuming that you still have water when the pressure is low, it just doesn't come gushing out? There are many places in the world like that, it's an infrastructure issue, not something a host has control over. Probably all the homes in the area are like that.
Where I live in Mexico, they only send me water a couple times a week, which goes into my cistern and then pumped up to a holding tank on the roof. So there is never strong pressure, as the system works on gravity feed.
Thise who travel outside their home countries need to be adaptable to things not working the way they should.
Be careful about offering your host things like promotions in exchange for a refund- that is essentially extortion, which is against Airbnb terms of service.
Much better to try to work something out with the host.
I realize that booking long term is much cheaper than by the night, but if I were a guest looking for a long term booking, I'd probably just book a night or two in a few possibilities first, to assess whether it works for me, before committing to a long term booking with its attendant cancellation policy.