I just skimmed this thread quickly so some of these might have already come but whatever.
I would like to see all these titles done either as films of the LotR quality or a HBO series (like Rome).
Mars trilogy (or Quadrilogy depending on how you look at it) by Kim Stanley Robinson
Foundation trilogy by Isaac Asimov
Many of the Robot series stories by Asmiov, would be a good series with Dr. Susan Calvin and Elijah Baley as the main characters solving robot and non-robot related crimes
Hyperion series by Dan Simmons, at least the first two books.
The Dune series by Frank Herbert, the Sci-Fi Channel did a decent mini series, but it could be improved on.
Star Wars: The Thrawn Trillogy by Timothy Zahn, probably one of the best of the SW novels. There are probably a few other good ones but after reading this and then 6-7 worthless SW novels I gave up.
Mass Effect series - only please god have a better ending!
Star Wars Jedi Knight (Kyle Katan) they would make a good few films.
Stranger in a Strange Land by Heinlein, always like that book.
To Sail Beyond the Sunset by Heinlein - if only to see Hollywood try and portray the rampant incest and crazy shit that's in this story!