Level 25 (Tier 2): Careful Aim is only the better pick in pure single target, sustained situations. If any type of AoE is involved in the fight, you should swap to
Explosive Shot. Speaking in terms of progression, typically the first 30% of a boss fight isn't really important. With that in mind, for the most meaningful DPS (despite a slight overall loss ~.5%) in most cases we'll be running Explosive Shot even in single-target. This will largely be fight dependent. While Careful Aim does have merit in AoE, it requires enemies to be within a certain health range which often isn't realistic in a practical sense.
Level 35 (Tier 4): In a sustained single target situation,
Steady Focus is our best option by a fair margin. If there is frequent target swapping or downtime, Steady Focus will lose some value. Steady Focus and
Streamline actually sim fairly closely in sustained AoE situations. That being said, there's no such thing as sustained AoE. When AoE occurs, we typically want to unload our burst as quickly as possible. Having to maintain Steady Focus while adds are spawning can be a huge loss. Likewise, Steady Focus loses value if we continually drop combat (think Mythic+). Thus, Streamline is typically our go-to for most AoE situations since it simply gives us some passive damage to
Rapid Fire without having to maintain anything. In 1-2 target situations where maintaining Steady Focus isn't realistic,
Chimaera Shot will take over (especially in sustained two target situations).
Level 45 (Tier 6): The go-to talent in this row is
Double Tap in every situation. However, if you opt to go with the Venthyr Covenant,
Deadeye gains a ton of value due to its synergy with Flayed Shot. Despite this, it is still recommended to go with Double Tap as Dead Eye falls short in comparison. Double Tap also gives you on-demand burst as well as more potential AoE throughput.
Level 50 (Tier 7): Lock and Load is by far our best option in pure single target. However, if there are frequent add spawns throughout the encounter, it may be worth running
Volley depending on their cadences. In AoE encounters or dungeons, it is always recommended to run Volley.