Yes, it's worth it.
I'm a Collector of this type of thing, I have all of the Limited/Legendary Editions of every Halo game when they have been available for purchase.
Halo 2 (Limited Collectors Edition)
Halo 3 (Limited Edition and Legendary Edition)
Halo: Reach (Limited Edition and Legendary Edition)
Assassin's Creed: Revelations Limited Collector's Edition (pre-ordered and paid in full)
For the Elder Scrolls Series:
Morrowind and Oblivion (Regular copy of the games as well as GOTY Editions) These aren't really Collectors Editions, but how often do back-to-back games win such acclaim? I expect Bethesda will get the rare hat-trick when Skyrim comes out. Three GOTY games in a row.
This CE for Skyrim is definitely worth it. Especially with the statue being made by IP Factory (their statues regularly retail for $150-$200 by them selves, so this is a great deal), the one of a kind Art Book, and the Making-of DVD's are always just cool. And for aesthetics, I really do like the special cases that the game typically comes in. It's usually much better quality/design than the a-typical DVD case that other games are packaged in.
So yeah, it's worth it to me. I love collecting the extra swag for the game series' I love the most. And Skyrim is one of the best that I've seen in a while (since Halo: Reach's Legendary Edition...)
Edit = almost forgot one...