Can I use Craft to Manage Site Access?
Yes, absolutely. You can use the {% requireLogin %} tag at the top of any templates that you want to protect, and you can create a login form very easily to allow registered users to login and access the site:

https://docs.craftcms.com/v3/dev/examples/login-form.html