I almost exclusively fish an Orvis Trident 2 weight that is 8'6" when I trout fish and I'm a Tailwater guy from Maine who fishes it here on big water. It is a tip flex and works well in close but has the nut to bomb out line as well. I can often line big fish while casting upstream and they don't mind the very light line splash from a 2 weight compared to a 5 or 6.... it's also more fun unless it's windy or I want to throw larger stuff like streamers.

Medium action rods load better for many casters making very short casts..... regardless of rod length. Many people find the stiffer rods have less "accuracy" in close quarters.

Good Luck