Hard wheat (red or white) has the gluten content you need for yeast breads. Red has a stronger flavor than white, but like anything, you get used to what you use. You can use this for ALL baking, from yeast breads to muffins, cookies, cakes, pancakes and so on. This is what we do, and we use red or white, whatever I’ve got at the time. We have not have regular white flour to bake with(storebought with nothing in it worth eating) in at least 2 years. In the beginning we baked bread with half whole wheat flour and half white. Over a few months we use less white flour and got used to the flavor of 100% whole wheat for everything.
Soft wheat has a lower gluten content (gluten is what gets all stretchy during kneading and holds the air bubbles when yeast is raising bread), so it doesn’t work as well for yeast breads. It does well in things raised with baking powder/baking soda like cakes, cookies, muffins. The texture when ground is softer.
Hope that helps!