Maine's population is 1.4M, which is almost twice New Brunswicks and more than most other provinces aside from the big 4. So if it were to secede and join Canada, it would be best to bring it in intact, instead of merging (and dwarfing) NB. I don't even see them yielding Aroostock county in that situation. Since that territory would change from being on the edge of America to being in the heart of the Maritimes/Quebec economic territory. There'd be a good chance for a decent boom happening htere, just from setting up the transportation corridors.
Getting America's thumb out of our armpit would be great for us economically for reasons others pointed out. The Gaspe/Riviere-de-Loup likely wouldn't like being nudged out of the way by it, but they still have the St Laurent so it wouldn't be too bad.
Sadly, it's just wishful thinking, but it would be nice.