Depends on what it is. If it's a game I was excited for that I felt the need to pre-order (which is very, very rare) then yeah. For example, I pre-ordered God of War: Ascension, and the steelbook has a really neat design; it has the series' omega symbol against a solid black background which gives it a particularly striking appearance.
It's gotta be something I feel passionate about though. I wouldn't go out of my way to get one for a game I don't care about.