These are questions and concerns that you should really express to the agent that is representing you, provided you have one. If not, you really should consider having an agent in your corner. The concerns you raise may or may not play into another's decision. However, as Larry and Reginald both pointed out, future street expansion could change things immensely. Based on your description of the lot, with one part adjoining another home in the subdivision, this sounds improbable, but without the facts and details, this is a hard situation to advise on. Some additional questions you might ask are: How long has this home been on the market? Was it on the market previously and did not sale. Why are the current owners selling? And you should speak with neighbors and express your concerns. They usually love to tell you everything you would want to know! Just look for someone outside and introduce yourselves.
If you do not have representation, but would like to, I would love to interview for the position!
It is very smart of you to look long term and at resale value. If it is a busy road then my first question would be are there any plans to now or anytime in the future to widen that road? Your agent can easily find that out. The noise factor is a concern but if it is not that bad and you continue to crow the cypress and maybe add to that in the future to minimize the noise when you go to sell that may become a non issue. It is definitely a negotiation point. Speak with your agent and make sure about all the material facts on the road an the area.
In the end make sure it is the home you want.
Hope this helps,