Fascinating idea. The Federation builds this Uber ship class and immediately stumbles into the Borg...
Here's the real problem: the Honorverse. The weapons as described by David Weber, blow away Star Trek. It is quite clear that too many limitations were imposed on Star Trek...
I won't go into why here. But... leaving 'Q Who' as the very last episode? Brilliant.
...and TNG's season two era of Starfleet behavior had them believing the Enterprise-D--backing up such a pompous belief about themselves (the polar opposite of Kirks' acknowledgement of the inherent danger in their missions as stated in his great "Risk is our business" speech from "Return to Tomorrow") was going to allow them to successfully face challenges they--apparently--did not understand. More than just another species possessing superior weapons, some--like the Borg--lived by a soulless credo beyond the understanding (or willingness to understand) of E-D/Stafleet, which set their collective heads on a date with a species-wide chopping block.
Why not end with Measure of a Man? If you're hell bent on ending in the second year? For... Reasons?
I explained the reasons, which were all in-universe / related to where Starfleet / humanity stood at the point of "Q Who" and Q's perception of the species:
The terror of the Borg 's attack in that episode would've served as both a superior judgement about arrogant humans (Picard conducted a masterclass in that early in the episode with his interactions with Q) more than that milquetoast pilot AKA "Encounter at Farpoint", and a bold way to end the arc of Starfleet/humanity.
At the rate Starfleet was going--exemplified by Picard's