@Courtney Olson - you listed a lot of different areas of North Alabama that all have different characteristics, so I'll throw in my two cents here on them.
Huntsville - it is tough to find deals right now that work. A/B class are going to be negative cash flow unless you can find an amazing off market deal and/or put over 30% down with a 30 year note. Even C/D class that cash flow decently are harder to find now. Several years ago, you could find a rough house in 35810, 35811, 35816, or 35805 for less than 100 a square foot, rehab it, and rent it for cash flow. Now, houses in those zips that need work are 150+ per square foot on the MLS, and even that much through some of the wholesalers.
Guntersville - we have one rental there that has done reasonably well. Rental market there for LTRs is not robust however, so make sure you have vacancy money built in to your projections. Probably a better STR market there, assuming they haven't change the rules on them
Athens - growing area, probably still a solid play for both mild cash flow and decent appreciation at this time with the right deal; we don't invest there, so I don't know that specific market well, but our west Madison properties rent easily.
Albertville - should be a reasonable cash flow play; would not go there if appreciation is your goal.
Muscle Shoals - no idea on the market there, sorry
@Michael Ewers mentioned Hazel Green and Meridianville - they are growing areas, but I'd be VERY cautious with new construction, as I don't see those prices being sustainable there. Finding an older house to rehab in those markets would be a better option in my opinion.
Madison - strong appreciation play, but negative cash flow without a unicorn deal or major cash down. Our rentals in Madison are robust but all purchased pre-2021. Property taxes in Madison city properties are also now ridiculous compared to 5 years ago, and greatly affecting cash flow potential (or lack there of).
Decatur - cash flow play; appreciation has lagged Huntsville/Madison/Athens though; we don't invest there
Good luck.