I am familiar with the area and the line. Yorkie has summarised it well. If I may add a few points for the benefit of the original poster who may find this useful (I apologise if you know this and it is teaching granny to suck eggs) :-
At present, the passenger services I shouldn't imagine to be intrusive, even if they go up to hourly, they are short and lightweight - undoubtedly you would soon stop noticing the noise.
The likelihood of freight idling in the loop will vary - this may be more intrusive if a locomotive is sat outside for some time. For various reasons, locomotives are typically left switched on and idling when waiting for time in a loop. The impact on noise will also depend on the location of the property in respect to the signal (at the exit of the loop); as that is where the locomotive will wait.
It is worth adding for the benefit of the OP that freight trains are less predictable than passenger - as said above, even if you look back at the last few days movements, many of the trains 'run as required', and others may be added according to customer demand.
The weekend diversions may be slightly disruptive as they are the intercity services between Leeds/Scotland and London; the schedule for this, however, is publicised some time in advance. New units are being rolled out on this line which have an integrated diesel engine rather than being dragged by a second locomotive as before - I would imagine (although I don't know for sure) this is less noisy.
To the original poster - you are welcome to PM me directly if you have queries about the area in general, I used to live nearby.