Designwise thst sounds very odd to me. I think rosebay rhododendrons might look more nstural among the trees, coupled with shade tolerant shrubs and groundcover. Ie a layered woodland. It won’t be a winter wall but you can look forward to spring all the more:)

holly, laurel, rhodies

You don't need anything taller than about eight feet to block the sight line and the plants should stay bushy at your sight level rather than growing tall to compete with the trees.

We have Camellias planted in out wooded areas, that would be ideal for what you are looking for. Foliage all year and flowers. Make sure you get those that are not bred to be short. (20 miles from Raleigh NC)

Rose of Sharon could be another one that would work. Growing naturally with some sun they get quite large. I did not realize how big the would get, I I have one that is peaking in the second floor studio..

What ever you do plant something with flowers or color, they will do more for your property than a dull wall of green plants with needles.

If you get a lot of pretty flowering plant, it might inspire your neighbor to do the same thing ane plant on his side of the line, further widening the barrier.

Don't expect a dramatic effect on noise from an additional planting of trees - a good way to see how generally ineffective these are is to go where there is a busy road passing through a wooded area. And how most of the sound comes through the vegetation so well that often the source will seem closer than it actually is.

If you have deer these may often browse accessible parts of arborvitae heavily. So that all branches from head height level down have a stubby appearance. Or worse: the one native thuja on my place, at the very north end of the maybe 60% wooded 5 acres has no foliage in the browsing zone. As though it is just too good a situation to be able to take shelter beneath it and snack on it during winter (if that is what is taking place).