I agree that I can't see it becoming a major longhaul hub, however two years ago I would have laughed at the thought of a holiday company basing 10 aircraft at STN.
If you told me 3 years ago that BA would have a network of routes from STN (even though it's City Flyer/Niche market) I'd also have laughed at your suggestion.
Stranger things have and do happen.