I can't say this is the most shocking event in Oilers history, but I'd have never believed you if you told me on June 29th that Comrie would be playing for the Oilers in 2009/10. Never a boring moment to be an Oilers fans since the lockout.
I will say that I think some fans are too concerned with the size of the forwards on Edmonton's roster - that the players are too small. I agree that one would prefer a forward to be 6'2" vs. 5'10", all else equal, but I think a team can win with small players up front, provided they are of a high enough quality. And quality, not size, is the issue most fans have with the Edmonton's roster; those issues are, unreasonably in my opinion, conflated by many.
So Comrie is another "small, skilled forward who doesn't throw his body around", but that doesn't make him a useless player. In terms of positives, Comrie's on a favorable, cap-friendly contract, a reported 1.125 mil. He's versatile, in that he can play C or the wing (LW at least, not sure how much RW he's played, if any). He may not be a PP star, but he's another guy in the mix, which, on a side note,doesn't help Schremp graduate to the NHL roster. If the team isn't looking good come the trade deadline, but Comrie produces, he'll carry at least some value on the trade market.
There isn't a ton of downside to this deal in terms of projected production vs. cost. You could make a reasonable argument that his money would have been better spent on some of the other available UFA's. Not that those players, necessarily, would be better value on average, but that those players fit Edmonton's perceived holes better than does Comrie. Additionally, it is possible that the addition of Comrie causes the Oilers to dump a player for less than he's worth, one that they'd have otherwise kept if they hadn't signed Comrie.
Obviously there's no crystal ball here, and I could hold a more concrete opinion if I knew this was the last move before the season starts. Without any other moves, there is potential for this signing to help the Oilers' 2nd and 3rd lines in terms of offensive production, provided Comrie can be a "50 point player", a step up on his most recent seasons but not a level he hasn't reached before. Overall, I am more for this move than I am against it, though I'm not convinced Comrie was necessarily the best option.