Although I'm further south than you I'd recommend Hunter if you want a butternut, it seems more productive than Waltham. My Walthams produced one big (TBF too big) squash each. The hunters produced four or five sensibly smaller ones Also look at Winter Festival, produced quite a few acorn squash about the size of a big grapfruit and the plants are quite bushy compared to some of the aggressively spreading varieties (yes I'm looking at you Bon-Bon.

)
Also I'm pretty certain that all the set fruit on my BNS (of both sorts) were fertilized by other things.... anything from a pumpkin to a gherkin.... If I was going to abandon a squash next year it would be BNS (I won't, I've got some hunter seeds coming), as it's the only squash you see in the supermarkets.... if I have a polytunnel next year I might try one in there to see how it fares, or maybe give it a cold frame or similar.... Hunter doesn't get that big (or didn't outdoors this year....) so
You could try swapping around for other things, and grow a big variety to see what works, to get you started I can send you a few Winter Festival seed if you PM your address
chrisc