Freelancer made it a roguelike.

It was always a sandbox, the levels were always meant to be replayed with different approaches, mastering the level, the routes, npc/item locations.

Not the case with 007, from what I heard. For a comparison: imagine every level would play out like a Mads Mikkelsen mission they've recently added - you can choose your approach, but there's more railroading.

This video covers the hands on demo developers were letting people play: https://youtu.be/uRFrrVRnZlI