Trent Roman wrote:
and it's probably worth recalling that, talk of alliances aside, the Federation actually had to face down the two major Borg attacks on Earth by itself
Not entirely true. The Federation did receive some assistance from the Klingon Empire in the Battle of Wolf 359. Granted, I would imagine the Klingons only had a few ships there, but the support of an ally was still there.