Enviar por SMS: Unveiling the faintest X-ray AGN populations in the NewATHENA Era: Insights from Cosmological Simulations