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

There isn't. It's a mostly linear experience with some variation, not a sandbox like hitman