MAC-based mechanisms don’t provide authentication as it is trival for anyone to spoof a MAC address and gain access.
Any authentication and authorisation setup will require ongoing management, if you already have a database of user credentials such as Windows / Azure AD it is possible to use those for both WiFi (WPA-Enterprise) and wired (802.1X) connections, or there are various cloud-based such as JumpCloud or Okta.