Depends on the beans, some take longer and more prep than others.
Okay. I'm shooting for a week of soaking this time. I added some garlic salt to the water and I'm leaving them in the fridge. Hopefully that will prevent anything trying to grow in the water.
Maybe I use normie beans or something, but I've never had to soak for more than about 30 hours. I think even with salt, your beans are going to get sour. I don't refrigerate soaking beans though, so I don't really know what effect that will have (aside from slow down the soak obviously) but I think it depends a lot on what kind of microbes live where you're at. At least where I'm at, it's easy to tell. Once the top of the water starts to have a foam of protein, then it's time to freeze or use the beans or else they'll be sour.
Speaking of, one thing you can try is to freeze it after soaking, which breaks the cells apart. Personally I tend not to find it necessary, but my grandmother* insisted it was the key to good beans. I find the cook time to be the most important.
When I do it, I bring the beans to boil for 20 minutes or however long it turns out to be, but that kind of ballpark, and then set them on a high simmer for the rest of the afternoon. This works if you're cooking them straight up (although I've never tried without at least some salt and garlic) or if they're already in something like chili.
Since types have been brought up, I'll discuss that as well, although it's hard to do it entirely in In English, because in English beans are just beans. In Spanish I use frijoles and habichuellas, which are small flavorful beans and medium sized ones with more of a starchy texture. I can verify that it works okay with alubias (the big white ones that make you fart) but I don't use them since they're not my preference. I don't know about porotos (big colored ones with more tooth).
As for some of the specific cultivars that I have in my pantry right now, I can only find an English name for kidney beans and navy beans. Other than that I'm only getting translations like "black bean" and "small red bean" which is maybe not so helpful.
Anyway, I've never had difficulty making beans of any kind so I don't know that this is the issue to begin with. But I'm also not tasting your beans so who knows what's going on.
*not the sort of grandmother who has been perfecting her technique for half a century though, don't assume the near-divine culinary expertise that some people attribute to that age class.