Michael - If you are going to use a motorized screen, you 100% want that motorized screen to be tab-tensioned. Otherwise you are just paying more to get the same screen wrikles that you could get from a manual screen for hundreds of dollars less.
For screen material, a positive gain, non-retroreflective, grey screen is one of the best in a room with varying conditions. Most quality manufacturers off this type of material for motorized tab-tesnioned screens.
Da-Lite:
http://www.dalite.com/products/selecting.php
delivers high contrast cinema vision
Draper:
http://www.draperinc.com/Screen_Pages/Screen_surface_definitions.htm
does not offer a positive gain grey screen...
If given those choice between grey (negative gain) and white (positive gain) I would recommend the white, positive gain screen. The grey screens really enhance projectors that are sorely lacking in contrast, color punch, and black levels. With today's LCD/DLP/LCoS projectors, it simply isn't an issue really. They can be slightly enhanced, but it is far more important to get a boost in overall light output through positive gain which then reflects in broader usability of the room in ambient light conditions.
One thing that is SERIOUSLY done poorly by builders and homeowners is that they ignore the lighting in the room.
The actual lights you put in the room is what determines how usable the projector and screen will be under varied conditions. You want to go with lots of smaller direction lights instead of one or two bright, full coverage lights.
http://www.avintegrated.com/lighting.html shows some examples of what halfway decently designed lighting can allow for in a room... Hundreds of watts of lighting to live by, while still having excellent image quality.
So, in order, I would use:
1. Positive gain, grey screen - NOT retroreflective (ala Greywolf)
2. Positive gain screen (1.3-1.5 gain, no more)
3. Grey screen
I personally have a .8 gain grey screen and, yes, it's at the bottom of my list. I would trade it for a 1.3 gain screen in a second, but there's a certain price involved in the type of screen I've got which makes it a bit cost prohibitive.