Large Language Models as Biomedical Hypothesis Generators: A Comprehensive Evaluation