I would say that a little CO2 is better than none, and I think the risks of inconsistent CO2 are overblown in low-medium energy tanks.
DIY CO2 is a good fit for low-medium light tanks. I've only run one bottle (yeast) on a tank at a time, which I replace about twice a month.
With DIY CO2 you lose controllability - can't turn it off at night, can't fine tune the levels of CO2.
So, make sure your lights are controllable to give you something you can tweak to dial in your system. LEDs with a dimmer/controller work well for this - you get fine-grained control of your light levels and you can change the intensity and photoperiod to minimize algae.
Also, make sure that you have movement of your water surface so you don't get an over buildup of CO2 in the first couple days of a new bottle. I know some people turn on an airstone at night to make sure there's movement at the water surface for this reason. I run an aquaclear HOB and when the tank is full, get a nice ripple across the surface that does the job for me.