It is a great bulb. You can use it for veg and the plants love it, compared to an hps for veg this is like crack
As for flowering, it's pretty awesome too. It will pack the same or similar yield as an hps 400 but with more resin. It's like having the quality of mh bulbs with the speed And nugs of a hps. Just keep in mind 400 watts of any will give you less yield and fluffier buds.
Make sure you hang the bulb in the position it was deigned for. Most likely horizontal. If the bulb is hung sideways it can cause problems. You can, however, buy vertical bulbs as well.
They also run slightly cooler which really isn't an issue with 400s though.
One ore warning, since CMH bulbs put out a very broad spectrum be careful about the uv it puts out. You don't want to go into any grow room without sunglasses CMH and mh are worse than hps. Although some CMH bulbs have a uv coating so it's not an issue at all.
Down the road if you expand a little you can add a 600 w hps and produce some serious weight and quality.