Medicines commonly prescribed to reduce people's risk of heart attack may have limited use for treating other diseases, research suggests.