"Leaving aside Littlestone's notion of Avebury being a giant pig pen..." That notion has yet to be disproved and among other things may have given rise to our world-renowned Wiltshire ham and sausage traditions ;-)
On a serious note, I do agree with you that 'smaller henges could be practical rather than ritual or astronomical' (or if not one or the other then perhaps a combination of both).