It's been a few years since I bought my kit so there will probably be stuff that is much easier to set up now. I went over to DMX mainly to keep the lights synchronised. The controller is not the cheapest either as I wanted something that was versatile and would last a while. In fact I've replaced the first set of lights I had with much better ones but am still using the same controller, which will handle most lights.
https://www.thomann.co.uk/stairville_dmxmaster_i.htm
The thing is that it will take time to set things up. You'll need the manuals that came with your lights because you'll not only need to put them into DMX mode, but also set a base address for each one. This will be via pressing buttons on more modern lights, or setting tiny little DIP switches on older ones. For each light you'll need to set the colour's red, green and blue (and perhaps white) levels - for every step in the sequence. A notepad will be handy.
Once you've set it all up though it's very easy to operate. The controller has buttons to select the colour sequence, whether it's time or music switched, and a couple of sliders to control the speed and cross-fade duration. And of course a blackout button. The one thing it lacks is the ability to dim the lights - the brightness is set to how you programmed the colours.
In our setup I have a pair of 4-way RGBA lights, so that's 8 lights to set up per sequence step. I've set up 3 or 4 sequences, one of which is a dim single colour wash to light the stage between sets. I also have a couple of "derby" lights that are not DMX controlled, they just do their own thing. It's also worth investing in some decent DMX leads (they are different spec to instrument cables, even though they use the same plugs!) and a terminator plug.
Hope that helps. It will be an investment in both time and money to set up, but easy to use.