Mate, I'm guessing that cloudy is in the fridge and still going hard... yep, that always has leftover sugars to ferment slowly unless you leave it alone for a month or so, its actually the only supermarket juice cider I find worth bottling. Kinda self regulated. Glad you like it
With the other ones, you get what you make. Fermented to almost dry that juice was not going to retain a lot of flavour. Its why I let it be a sweet cider by chilling it before it finishes. My suggestion, mix with some fresh apple juice in the glass to drink, it would be cider (alcohol) + fresh juice flavour.
PS: I forgot to mention before, even though the temp in the fridge door might be 3C, the yeast will push it up a little, that wine yeast is really tough, it ferments at even really low temp, slower but does keep doing it.
PPS: Mark, thats an awesome read. Not sure I'll ever be arsed to work that hard for cider but gonna pick something easy up to better mine