The DME could be associated with a VOR or an ILS, so having VOR in the title is necessary to make the distinction. Furthermore, the VOR radials define points (SLOAF, CUMBE, GOVES, a "VDP", and the MAP) that are required for the approach and for the Missed Approach Procedure.
By "hold is even crazier" I assume you mean the Missed Approach holding pattern. The holding pattern itself is quite standard -- along a radial of the VOR. Perhaps you're referring to the Missed Approach Procedure routing itself, which includes a segment defined by a VOR/DME arc. While uncommon, I don't believe they are unusual.
Flying an arc (without an FMS) is becoming a lost skill. If there's a way to practice it, do it!
.