I believe that gives pros and cons to solutions related to your needs.
For any more specific answers, I feel it’s dangerous to try to do so in a Forum without the benefit of a discussion focusing on needs, tradeoffs, and details, which I do daily with clients.