I know that at my church (assuming they truly had changed) they would be welcomed with open arms although a registered sex offender would have conditions placed on their attendance (such as being prohibited from being in the portion of the building that houses children's activities). Christ's regenerating work is not limited to person's who have clean backgrounds.