There are many ways to get what you are looking for. Each approach has benefits and costs that can only be calculated by you, personally, based on what you want and your unique value system. Some people are willing to spend an enormous amount of effort to achieve exactly what they want; others, not so much.
I recommend you look at 'Virtual Libraries' and then 'User Categories' to start with. They are explained in the user manual at
https://manual.calibre-ebook.com/gui.html .
Create a disposable test library and try different options until you find a combination that works for you personally.