As long as your computer can handle it, you gonna enjoy destroying everything, EVERYTHING yes you can destroy any single things in this game and do any kinds of destruction to your heart's content, also a big plus for custom contents created by the community (custom weapons and custom maps) So if you started to get bored with vanilla maps and weapons, then i suggest you download some mods created by talented modders.
I played this game since day 1 release and i never get bored of it even without mods, the missions are great all you need to do is use your brain, your mind is a great weapon to beat any missions in this game. Think smart, play smart.