Wafer cones, to me, are the only kind of cone to use. Just the right amount of sturdiness and little flavor to interfere with the ice cream.
Waffle/sugar cones are far, far too hard and brittle. They take a too much pressure to break and then fall apart unpredictably. They are also way too sweet. I don’t want the cone to overwhelm the ice cream.