[good sump pump advice snipped - thanks]

Does your house have excessive humidity (e.g. windows fog, condensation
on sills)? if so, the roof is undoubtedly in bad shape, letting in
excess moisture in addition to any obvious water leakage.

No, everything inside is fine. No moisture, no leaking, no marks on the ceiling.

Just puddles on the roof!