Thanks for reaching out and welcome to the community!
The HPX370s were (and still can be) great cameras. I've purchased many of them and used them many times throughout the years. They are a native 720p sensor, so I have definitely seen less than ideal results by running them in 1080p/i modes. There could have been some settings that also were not helping your situation, though.
So, first and foremost, make sure you have more than adequate lighting. All cameras like light, and having good/adequate light will set you up for the best success no matter what camera you choose.
First Things First
Before choosing the camera/lens you want, it's good to determine what your expectations and budget are.
For example, you can get a "cinematic" look like you're describing (24p for worship and 30p or 60p for preaching) with both cinema and studio broadcast cameras. So is the desire just for the cinematic frame rate, or is there also a desire for more shallow depth of field that larger sensor cameras can only achieve?
Also, do you want things like CCU (or CCU-like) control of camera/lens settings like iris, shutter, white balance, etc.?
And what type of budget range are you looking to stay within?
And lastly, the HS410 switcher you have will only support SD or HD-SDI formats like 1080i59.94, 720p59.94, 1080PsF24, or 1080p23.98. It won't do formats like 1080p29.97 or anything higher. So I would also keep that in mind if you wish to keep the current switcher. Or plan on replacing the switcher as well if you want more/updated formats.