Yes, a no-show penalty can activate a membership!
If a membership contract is set to start upon the First usage, any of the following actions will activate the membership: a check-in, late cancel penalty, or no-show penalty.
Additionally, if the membership is set to Bill on Start, these actions will trigger a revenue event and push the first membership charge.