LLMs for Bayesian Optimization in Scientific Domains: Are We There Yet?