Summarizing what a number on here have said, most every drug has Risk/Benefit that you and your doctor must weigh. If you have history of heart disease or are at risk of developing with underlying conditions such as diabetes, then statin therapy if the best to help lower your CV risk as some are proven to actually reduce the plaque in your arteries.
With that, generally the old statins such as pravastatin, lovastatin, simvastatin and others tend to have higher rates of myalgia. The two that tend to have least side effects are Crestor and Livalo. Personally I could not take Zocor or Lipitor without the aches. My doctor settled on Crestor 5mg and another drug called Welchol, it is not metabolized in liver or kidneys and together I get the drops I need with minimal side effects and I get the heart protection from Crestor. Welchol is also a diabetes drug which helps me with my A1c as well.
If you just cannot take any amount of statins and have high ldl and risk factors your best bets are the injectables Repatha or Praluent, which have large LDL drops and provide heart protection. Or, you can try Welchol and Zetia together for a decent drop.