There's part of an area in Half Life: Opposing Force that has something like this. You later end up using the cannon yourself to open up the path forward.

You could also be thinking about a couple of parts of the original Half-Life as there are a couple of times with mortar fire (including the ability to use them yourself at one point), and there's definitely at least one rocket launch silo in the game.

Depending on how strong your recollection or how muddled your memories these could be a match.

Thanks for the suggestions guys but none of them seem to be what I'm looking for.

Some more details; I'm pretty sure I played it on either the Xbox 360, Xbox One, PS3, or PS4. It was definitely an open world game of some sort, and I think was on an island.

It might not have even been a missile silo, it could have been artillery firing from long distance. You'd hear a thunderous sound when it fired, and it took several seconds to land, with a whistling sound.

There was a restricted island in ghost recon breakpoint where you got blown up if you tried to get onto it, but this isn't what I'm thinking of. There was something similar on an island in Just Cause 2, and the buildings on top of the mountains in Just Cause 4 (but that was lightning).

The Boomers in New Vegas? https://www.youtube.com/watch?v=r9IAY7XBRd0&t=120s

Mercenaries: Playground of Destruction maybe?

You could try [email protected]

Oh dang, this rings a bell!!!

Any idea of what year you first encountered this game? Also what console it might have been on?

My mind first jumped to Siphon Filter, but I didn’t find footage of a silo that launches missiles at you.

You sure it's not just one of the Just Cause games?

What era - early/mid/late 80s/90s/00s ?

What hardware - arcade/nes/pc?

Something similar was in one of the last Serious Sam games.

First person? Top down?

There might be a mission in one of the Gears of Wars like this. It sounds vaguely familiar.

The very last level/challenge of PilotWings was kinda like that.

Perhaps Metal Gear Solid V ? Or some sonic game ?

Just Cause 2 has a mission, where someone launches 3 rockets (or satellites?). You destroy 2 on foot, but the third one launches, then you have to steal a jet plane and destroy that rocket before it reaches the orbit. Pretty cool mission.

But it does not match the rest of your description.

An old james bond game

Everspace has silos like that, but many games have stuff that is similar. We definitely need a bit more info here. Also, like @[email protected] said, [email protected] is the correct community for that.

Are you positive it isn't Just Cause 4? Because that's the first thing that comes to mind for me.

Nellis AFB in Fallout New Vegas functions pretty much how you are saying.