Are the Hunters I've turned into vampires useless and a waste of points or is there a function for them that I haven't realized yet?
it’s just personal preference. It’s usually better to drain them for the exp, but if you want to make them all vampires, remember that you can always train with Ophelia or Bianca (if you have her) to recover the exp you missed out on.