I'm not quite as drastic as RLeep2, but my favorite fly rod for modest sized streams is a 7-foot, 5-weight Orvis Rocky Mt. fly rod. It is probably more than 25 years old, and I will eventually break it, I'm sure. I don't know where or how I'll replace it. When I look at tackle catalogues, etc., I do not see any such rods.
I once had a 5-wt, 8.5-foot Sage XP, but a guy wanted it for his father, so I parted with it. I should have kept it. It was the best dry fly rod I ever had. I replaced it with another Sage, but it isn't as nice to cast.
So, Lark, I'd suggest an 8.5" or 9" 5-wt if you're going to fish relatively larger streams. If money is no object, you might like a Sage. But, I know guys who swear by St. Croix rods.
Good luck.