Yes, you want weight. Thats the trade-off. Theres always a trade-off. Larger anchor = more weight = more holding power. Larger chain = more weight = increased catenary = more holding power.
Chain also guards against chafe. And your right, boats in coral, rocks and areas with obstructions need it ,but, you have to have chain or else the amount of scope you have to let out will get ridiculous.