What I'd like to see is a dynamic, open-ended Aliens game where you can freely explore the galaxy and investigate space stations, colonies, etc, where Aliens may be building hives. It would basically be X-COM, only under the Aliens mythos.
The Alien universe could certainly take another route which strays from the typical shooter. Unfortunately, any hope of that went down the drain when the Aliens RPG got cancelled and we'll never know how it would have panned out in the grand scheme of things and to what degree those RPG elements would have allowed it to be a little more open.
I would love to see the Alien universe become just that: a universe filled with the examples you provided.
However, Fox has a notorious death grip on the license and it's actually surprising to see them give Gearbox this much freedom to not only use the Alien name but to cast Colonial Marines off as a type of 'sequel' to Aliens. Why they would give Gearbox, of all companies, this license and freedom really puzzles me but I have a feeling that it falls in to the realm of 'doing what we've been doing all along' which is to provide a typical FPS experience.
Pitchford can definitely talk the talk when it comes to this universe which may have caught Fox but whether he can walk that line is an entirely separate matter and, judging by the video, seems he may have a lot of explaining to do.
I would love to see a company such as CCP pick up the license due to their experience with creating a vast sandbox and have (or will have) experience shaping that sandbox to match FPS combat as shown in Dust 514.
That'll never happen though.