This paper presents an in-depth investigation of the biogeochemical modeling approaches applied to underground hydrogen storage. It delves into the intricate dynamics of hydrogen in the subsurface, focusing on small (pore-lab scale) and reservoir-scale models, highlighting the importance of capturing microbial, geochemical, and fluid flow dynamic interactions in porous media to simulate storage performance accurately. Small-scale models offer detailed insights into localized phenomena, such as microbial hydrogen consumption and mineral reactions, and can be verified and calibrated against laboratory data. Conversely, large-scale models are essential to assess the feasibility of a project and forecast the storage performance, but cannot be proven by real data yet. This work addresses the challenge of transitioning from fine-scale to reservoir models, integrating spatial heterogeneity and long-term dynamics while retaining biogeochemical complexity. Through the use of several simulation tools, like PHREEQC, Comsol, DuMuX, Eclipse, CMG-GEM, and others, this study explores how modeling approaches are evolving to incorporate multiphysics processes and biochemical feedback loops, which are essential for predicting hydrogen retention, flow, and potential risks. The findings highlight the strengths and limitations of current modeling techniques and suggest a workflow for exploiting at best existing modeling capabilities and developing reservoir models to support hydrogen storage appraisal and management.