Theres only one piece of advice regarding writing stories for enjoyment.
The only way your going to write a enjoyable story for other people to enjoy is if you , yourself enjoy writing and playing the save your in. There's no point in writing a story for the benefit of others if your not going to enjoy it yourself.
For example the one above.. is a really difficult challenge and you need to know what your getting into before you even start starting a story or you could run into some difficulties later on and the story might not go the way you want.
As for a story that may appeal to a large majority..I always enjoyed reading stories where people are taking Fallen giants back to glory. Any league at all really , for example.. Roma in Italy , Werder Bremen/wolfsburg in Germany , Bordeaux in France. Though some of the ones i mentioned aren't exactly fallen giants , they haven't really been graced with much glory compared to their history.
By no means am i telling you what to do, this is just my opinion. I've read alot of stories and seen alot of them not pan out for the best because of the writer not enjoying it.