I've been trying things out in that same view with 3 text documents labeled the same as your alien movies.
Unfortunately, Finder still lists it the same as yours with the 3 on top, and Resurrection under that, giving it a 3,4,2,1 order.
Finder is seeing the "3" and placing it before any letter in the other titles. It is also seeing the "R" which comes before "s", and placing that before the other two titles.
The only solutions I've come across so far are:
-Re name them to:
Alien 1
Alien 2
Alien 3
Alien 4
-OR-
Alien I
Alien II
Alien III
Alien IV
the other solution is a little less practical. .
"Get Info" on each movie, and place a number in the "spotlight comments" box. Use that finder view to sort by spotlight comments.
that would order the movies, but throw them at the bottom of the list.
I'll see if there is any other Method. . In the mean time, check out
iVideo 4. It may help if you get fed up with the Finder way, but don't want to use iTunes as a movie library.
Edit:
My Final solution. .
Create a Sub-Folder called "Alien Quadrilogy". Place the Alien movies in there, and do the spotlight comment thing I mentioned above. Sort that folder by spotlight comments, and they will be in a 1,2,3,4 order upon double clicking the folder.
It also works (for me anyway) if I enter the folder in Grid view, then select column view. (ie, it keeps the sort order as "by spotlight comments" even upon switching views)