Text this: The cosmological significance of boundary term in non-metricity gravity