I also do not like the aggressive marketing used by Rocna anchors.
Whoever said "horses for courses" has it right. The right anchor will work in the right place.
If you keep a couple different ones aboard, all will work out. We "inherited" heavy ground tackle that came with the boat and works fine for us. The prior owner considered his anchors to be his insurance. Therefore--big, heavy, oversize anchors and chain. We've used a 105 lb CQR with 1/2" bbb chain everywhere in every type of situation. It always works and holds in heavy winds. The only time this wasn't true was on top the river rocks in the Dana Point Harbor. There was no wind so we only drug slightly but we could tell we were dragging. Further, if one is a moron about plowing the CQR anchor through light silt, then it won't hold there either. We do carry a 95 lb Danforth which would work well in silt but have only deployed it once (as a stern anchor while the CQR was in use as primary on the bow). We also have used our little (30 lb-ish) Norhill kedge anchor as a stern anchor in silt/mud successfully. We have a 120 lb Herreshoff/fisherman anchor that will get used someday when we find ourselves in the middle of rocks and seagrass. Our final backup anchor is a brand new 105 lb Delta/CQR knock-off that has never been used but we'd likely make our primary if the CQR were lost somehow.
Heavy ground tackle is the rather no-brainer way to go, from what we've seen. Heavy anchor, heavy chain, adequate scope (we've always been able to work with lots of scope which helps) it just doesn't take a lot of talent to anchor with this combination, IMHO.