Steve:
A lot of the lighting effects you can create also has to do with the beam spread of the lamp you choose. I have done landscape tree lighting at a few country clubs over the years, and although most were MH, in varying wattage and fixture & lamp types a limited number were low voltage.
You can find a wide array of lv bulbs and fixtures, as well as a very wide array of MH fixtures and lamps, but expect to spend quite a bit for the 'exotic' items.
The RUUD and/or Rab are good choices for resi, unless the budget can handle the professional fixtures.
