The National Institute of Health and Care Excellence (Nice) said too many people are being "offered expensive treatments that simply don't work".