Statins are amazing drugs if you have moderate or high vascular risk (which included all with coronary artery disease and nearly all with stroke). So I wouldn't say never
As a rule of thumb they reduce risk of further events by about 20%.
If your vascular risk is low (i.e otherwise healthy, only moderately raised cholesterol, normal BP, no diabetes, no strokg family history) this risk reduction is not too far off the (very small) risk of side-effects so the benefit is less strong.
If in doubt about your personal risk a coronary artery calcium score can help refine the decision.
Statins are the most widely prescribed drug worldwide so it is inevitable that some will report problems. Their bad name on the internet is way overblown.
Most doctors (including myself) who have a raised vascular risk are very happy to take them