Does anyone know if custom records have any limits or tiers regarding the maximum number of records that can be created?

as far as I know none - but no matter what you do there will some threshold for efficiency

None documented as far as I know. There might be undocumented limitations, but I have seen entries up to a few million with no issues