I think both types of campaigns have their benefits. Hand crafted campaign missions are usually well built and challenging. On the other hand they are repetitive, once i've finished a mission I usually have no interest in flying it again. Also if it's a really tough one, I don't like having to re-fly it over and over again until I succeed....especially if it's beacuse there was one vehicle left I couldn't kill beacuse I ran out of ammo. :)
Also other then each vehicle thats specifically placed the world is often completly empty. There usually is no "front line" that you have to cross to get to the target. Overall I find most non-dynamic campaign missions I feel like I'm flying in a barren world until I get to the target. I'd love to get shot at 1/2 way to the target. :)
Dynamic campaigns are good because you never know whats going to happen in the mission, and it's always different. The F4 dynamic campaign is by far the best I've ever seen ( I honestly can't imagine why anybody would dislike it). You can be on a CAP mission and nothing happens, or all hell can break loose. I find the not knowing the most exciting part. You have a brief and a rough idea what to expect and that's about it.
Don't get me wrong, I love BS and am enjoying the first campaign. This sim is long overdue and I'll be playing it for years to come. I can't wait to see what DCS comes up with next!