Can you recommend some then? And which ones should be avoided for those who aren't heavy wine drinkers?
I usually prefer rieslings and riesling trockens (whites). Rieslings are generally rather sweet, so they're easy to drink. But you could also try a merlot or shiraz (reds).
If you want a wine which is so easy to drink it feels like juice, you could look for a red called falling feather. It's so sweet, I almost puked after half a bottle.
Bit of a duh question but asking coz I dont like the taste of alcohol in general so everything tastes awful to me
Any recommendations for a good red wine?
Various bodies of research put the surroundings of wine consumption as more important to the experience than the contents of the bottle. At least to some extent, paying more is paying for a better and more sophisticated label, and the feeling than you have paid more and so the wine must taste better. Remove all that and most people couldn't taste the difference.
Whether than matters or not is for you to decide.
Red wine wise, any merlot or malbec around £5 is fairly safe.