Elucidating structure over atomic length scales through advanced synchrotron-based methodologies