I assume it would look something like this:

Race: Half-Elf
Class: Hexblade 1, Valor Bard 19.
Ability Scores: 8 STR, 15+1 DEX, 13+1 CON, 8 INT, 11 WIS, 15+2 CHA.
ASI's (In no particular order): +2 CHA, Elven Accuracy (CHA), Sharpshooter, Crossbow expert, Medium Armor Master

Using spells like Quick Quiver, haste, or other combat spells.

Is this any good as a archer, or does the dpr of gloomstalker / fighter archers or hexbows outweigh the advantages of being a full caster in addition to archery?