> during the day I get groggy, during the night my sleep is worse (I know, counterfactual, but so it is)
Have you tried lighter wines or prosecco? I've had some summer wine from a grape variety called Inzolia in Sicily. Quite light on alcohol, tasted a bit like lime water.
https://www.wine-searcher.com/grape-715-inzolia
My experience is that grogginess really depends on the wine that you drink, but it always ruins my sleep if I exceed two glasses (150 ml). For instance I would almost never drink high alcohol (>13.5%) or high sugar content Rieslings. They almost always give me headaches.