Honestly.........I used to drink semi-sweet wines to get drunk.
Franzia boxed wines are good. The Sangria is quite nice.......I gifted a few boxes to casual wine drinkers this year. There is also one called "Chillable Red" which is also a semi sweet red wine.....not too bad.
You want to stay away from REAL sweet wines, like desert wines........they will spike your head.
Another good one is Carlo Rossi Blush.......if it is not sweet enough, mix in a little ginger ale.