Missiles are... polarising. Some people love them, because they're fun to use, some people hate them, because they consider them "a wasted hardpoint"
The truth is in the middle, as usual. They are nowhere near as effective as the rest of the Class 2 weaponry, but they DO have uses.
If you ask me where would I equip them, it would probably be something like trading/mining T9 or T10. They are pretty much useless against bigger ship, because of the low DPS, but they are quite effective against smaller ships.
The key word is blast radius. If you hit an Anaconda with a missile, they will just shrug it off, maybe you'll do some damage ot one module or weapon you accidentally hit. But hit a pirate in an Eagle or Viper and you're wrecking their thrusters, weapons, utility mounts... all in one volley, because the blast radius basically engulfs the tiny ship.
To me, they are very much a defensive weapon on a ship that is not capable of a dogfight. Something to fend off smaller ships. As an assault wapon they are unsustainable. They are expensive and the ammo is very limited.
And I'd always go with guided missiles, be it pack hounds or regular seekers. Dumbfire missiles dish out more damage, but honestly, if you're trying to hit something with a slow projectile, you'd be better off with something like a plasma accelerator.