I’ve had Philips Hue and several different bulbs installed in/outside my home for 7 years or so. Great for small spaces or with low hanging fixtures. I would say the only downside is the lack of brighter bulbs, the most they will go up to is the equivalent of 60W but they do promise energy savings and I noticed that when I switched all of the old bulbs in my home.
You will quickly get bored with the idea of using mood lighting, however, because of the flexibility of the software and APIs, you will be able to tap in your TV or PC in the living room for example or your speaker systems to create living scenes.
Philips provides full control of the hub through your phone, web API and/or your home network. There are small PC software applications you can use to control and manage the bulbs. The phone app is only required for initial configuration and the hub provides its own wireless connection to the bulbs using ZigBee.
As an added bonus, the bulbs can relay to your hub using each other as a repeater so distance is not necessarily important. The app Philips provides also allows multiple hubs in your home.
This product however is not intended for office use and the capability for VLAN tagging has been stripped from the Zigbee software.