I choose not to discuss religion much. I've been abused to it to the sum of being screwed out of a few million dollars. Or, more recently, they book the event then say "hey, we found someone else to do sound" 2 days before the event. I had many others inquiring about that date. That's the thanks I get. Then they start spamming me. Lovely.
At any rate, this is a nice thing about ADJ and Elation.
Let's say you are starting small, and you go with a console. Well, ADJ has many good yet feature rich entry level controllers that will more than suffice. HOw long would they last? Well, that's really up to what the lighting operator needs and is growing to. And that's where things really go well. You can upgrade to bigger and more feature rich consoles or go software control. Either way, there are upgrade paths to keep you within the same company, thus ensuring a good strong path for support.
Regardless, whatever fixtures you choose to purchase and buy, you're supported as well. If you're going software with MyDMX or CompuLive, you can use the ready made profiles or build your own. Some of the bigger consoles also have similar capabilities, but I don't have any hands on time on those, nor will I likely ever, I'm a sound guy.
Since you're choosing to go MyDMX, this is my suggestion:
Within reasonable limitations, try to design your room as accurately as you can. Once you've done that, you're probably going to want to do things like add trusses to the ceiling and start doing your lighting designs. What I would say is that if you are planning to mount trusses th the ceilings, please do have a professional engineer, contractor and rigger involved. I'm not saying you need to have motors and fly points. There is no harm in permanently mounting trussing to your ceilings as it will provide not only a safe and stable mounting option for your lights, but with the trussing in place, prevents you from putting stuff right below the ceiling and thus allowing adequate ventilation. If you're planning LED, this is less of an issue. I do recommend Global Truss for your trussing. Yeah, it's expensive, but it is strong and very safe.
Another few tips: Things are going to change. Perhaps you have a special event and need to re-aim cans, for example. Or you get new stuff, or maintenance. For whatever reason, ensure that you have a safe and secure way to reach your lights to make any changes. Remember, bulbs do burn out from time to time and need prompt replacing. This makes LED a better argument.
Then again, you can spend MORE money and go with mostly moving head units. The only issue with that option is that the cost is a lot higher per fixture. The advantage us that you should theoretically never need to change fixtures aiming.
Choose carefully though. For example, and it's a competitive brand, but I say and use their name and a model number for example purposes only. I have two Chauvet Q-Spot 150 moving head lights. These work great, but I have two complaints about them: The bulb is ON the whole time the fixture is on AND that it uses a shutter and does not have a dimming feature. For me, I'm mobile, so this isn't a major concern. I want the fixture either full ON(shutter 100% open) or shutter closed, but I wish I had dimming now. Oh well, you live, you learn. It's still a great fixture. But, I recommend against going with this fixture in a permanent install because of the full-time ON bulb thing. THis means you'll have more frequent maintenance cycles and will need to carry a small inventory of replacement bulbs. My ratio: 1 spare for every live bulb. Guarantees up-time.
Safety cables: Yes, it's an issue and must be addressed, Don't forget to use safety cables. Just in case. You don't need to send them "to god" before their time! Never let safely lapse. But if your entire truss is falling, I think the fact that you are using safety cables becomes trivial when the roof is coming down on people.
Clamps: I like the O-Clamps a lot, but in this case, I'd recommend something like the ADJ ProClamp, S-Clamps, C-Clamps or any all metal constructed clamps. In my case, I have a lot of MegaClamps, and I really like them, super solid, and I think solid aluminum, I don't think they are all steel. If you go that route, you may wish to go to Sears or some other hardware store and construct yourself some tools for helping to secure the clamps down quickly. Keep these in a well-marked tool bag marked "lighting tools, please return when not in use" so they have a smaller chance of getting lost.
DMX cabling: I'm running into this more and more. Some installers are lazy and assume that because DMX is wired identical to microphones, that it uses the same cable. Please don't be fooled. Whatever you do, please ensure it is rated for use as DMX, or if anything AES/EBU, which is a digital audio standard that, strangly enough is also wired the same as DMX and XLR mic cabling! A recent poster said they used Canare Starquad cabling for their DMX. Well, I love that cabling, but it's microphone cable, NOT data! Right tools for the right job, please! Also, run dedicated power up there as well and plan ahead. At some point you're going to add stuff, so be ready for it. ANd while you're doing that, make sure you MARK the circuits that lighting is on and ONLY use those circuits for lighting. Turn them OFF when not in use. This can save a LOT of money in electrical bills. It doesn't matter of you use a switch, but I'd prefer hitting the breaker, so if code allows, put the breaker box inside, under cover where it is accessible whenever people are in the building(but not necessarily accessible to everyone). Nothing sucks more than having to go and pop breakers either on or off when it's raining or snowing or extreme weather conditions!
Back to MyDMX: You can download it and start using it for free!!! But, you can't really use it until you buy the dongle. The good is you can start doing everything with MyDMX now. The bad is that you can't actually do any true DMX control until you buy it, but that's not so bad.
With a scene based structure, you can do a lot with MyDMX. Even so, with the proper add-on controllers, we're finding new ways to add more functionality and features to MyDMX. Not just quick scene change triggering, but also control over other channels.
So, before you plunge, download MyDMX and start playing. I think then you'll have a better feel for it.