No not really imo.
The only CE I've ever brought was the FONV one cause I'm a huge FO fan and even that came with stuff that is now gathering dust (I liked the comic though).
I think some people just like extra goodies to come with their games.
I like art books so sometimes it is worth it to me simply for the book or for the making of dvd
I've never seen a CE that was a must-have. The occasional statue or goodie is nice, but would you really put it in your living room?
The collectors will tell you yes, they're worth it. The question of this thread could be valid for every single hobby on this planet. Yes, some people like to spend more money on CE and for them it's totally worth the price.
Usually its the only way to get the art books which i collect, also i dont mind some of the statues, Witcher 2 i like the bust and the medallion, Fallout 3 bobblehead and lunchbox, Halo reach team statue and black box, but weirdest was Fear 3 naked pregnant Alma with a glow in the dark fetus, no idea what they were thinking with that, the tin cases ive never understood.
I only buy Collectors editions of game franchises i really enjoy (like the Tales games), as they usually come with great bonus's only available to the CE buyers that while may not add much to the game itself, it does provide memorabilia for us hardcoe fans.. (Art Books, Figurines to add to my ever growing shelf, the OST, exclusive DLC, posters, etc..)