Well, the D-Backs got a guy to eat innings on the back of the rotation. Marquis isn't going to wow anyone, but he will generally keep a team in the game. He's supposed to be a four-pitch guy, but he's primarily a fastball/slider pitcher with a half-decent cutter. His fastball's been hammered of late. He likes to work off the plate with fastball/slider to set up his cutter. He's not going to get a lot of swings and misses. If he's on his game, he'll get a lot of ground balls, especially if he's spotting his fastball.
He had one great year for the Rockies, which is encouraging, since Chase Field and Coors Field are somewhat similar in how the ball flies. The downside is he has bone chips in his shoulder (IIRC) not long after that and hasn't really been the same since.
Collmenter ... I think you're right about him being a long reliever/set up guy. His stuff is very mediocre. He's all about delivery and control. He can't make it through a lineup more than once because is best pitch is a 78MPH change up off of a 85MPH fastball. Hide him between a traditional starter and a hard-throwing closer, and he can be devastating because hitters' timing is so whacked. But make him throw six innings and guys will just sit on his fastball. He's a two-pitch pitcher who will never be any better as a starter as we've seen, and now that he's facing teams for the second time, they need to move him to the bullpen now.