Cider from fresh juice is always better.
Getting the blend of apples (bitter sweet, bitter sharp, sour etc.) is the important bit.
For general cider making, a blend of apples is always good. Normally a mix of dessert and cookers at a ratio of 9 dessert to 1 cookers works well.
I used to work for a (fairly well known) cider company, and come autumn time you have a huge glut of apple juice. We used to pasteurise the excess into huge "bag in box" type containers, and deal with it in the quieter (winter/spring) months.
Cider from supermarket juice certainly works well, but I find that it can be a bit bland. I make it quite often, but normally with additions. I think that elderflowers work well for a refreshing summer drink, chilli and ginger for a warming winters eve, and this time of year a few mulling spices go down a treat!!!