To add an answer to my own question, I'm going to guess that, based upon other comments that it is likely to stay on SUSuper User. I'll use Excel as an example as to why.
You could ask a question which you're hoping to have resolved using a worksheet formulae. It turns out you can't and VBaVBA is required (programming, regardless of complexity).
Assuming SUSuper User stopped VBaVBA questions (for the purpose of my example only), it would mean knowing where to ask this question is very difficult (and could even possibly lead towards more cross site-site posting I assume) since the OP possibly can't predict the best way?
Or, in situations, the user will have to wait (possibly without getting any answers) while the question is voted on for it to be moved to the correct site (where then they will get a great answer I'm sure). I guess it could even result in 'poor quality' answers; for example, there could be a solution using a worksheet formula which isn't as good (speed issues/memory, memory issues, etc.) as VBaVBA (or vice versa). The user is now forced into this answer!
This just isn't particularly good for the OP all round. I admit we don't get paid to answer questions, etc, but, I think the majority like to answer quickly (for their own satisfaction or reputation points).
I'm hoping we can state some wheresomewhere in the help section that this site does accept scripting questions in the certain situations already outlined in the other answers (and Daniel Beck's comments on the OP).