I tried the no-flush at 1500mg a night for 3 months without effect- found out that there isn't any research supporting that it does. Regular niacin, time-release niacin or a prescription version called Niaspan all have research to support their effectiveness. An aspirin or two 1 hour before taking it helps reduce the flushing and you need to start low( like 500mg)and work your way up in doses( no more than 2000mg). The regular niacin is the least liver toxic, but has the most sides. The Niaspan is only slightly less toxic than the over-the-counter time-release version- pretty much any time release vitamin or med will impact the liver. My doc put me on 500mg of Niaspan at bedtime and that had a significant impact lowering my LDL's by about 15 after just two months. Its best to take it before bedtime because that is when your liver is synthesizing LDL cholesterol and niacin reduces that process.
"However, there is something called red yeast rice that works really well for a lot of people. "
I would steer clear of this because it is very liver toxic- it is the same thing as a class of drugs called "Statins" like Lipitor, Zocor, and Baycol ( probably heard abou that one in the news). If you do take it you need to get your liver functions checked every month and get an eye exam every month minimum. It also increases the liver toxic effects of niacin( although they are prescribed to be taken together).