Sturgeon can be targeted in various locations across North America, but it's important to note that they are a protected species in many areas due to past overfishing and current conservation efforts. Based on the video context provided by Jon B. and Mike Iaconelli, it seems that certain rivers and lakes in Canada, such as those in New Brunswick, offer legal sturgeon fishing opportunities, especially for the shortnose sturgeon, as long as you're using barbless hooks and fishing after July 1st.
In the United States, sturgeon fishing is also popular in the Rainy River, which flows between Rainy Lake and Lake of the Woods, where conservation efforts have helped their populations rebound. When targeting sturgeon, it's common to look for deep holes or flats with strong current where these bottom feeders tend to forage. They are opportunistic feeders, so using baits like nightcrawlers, cut fish, or commercially prepared sturgeon baits can be effective.
Always remember to check the local regulations before you go fishing for sturgeon, as there may be specific seasons, gear restrictions, and catch-and-release only rules in place to protect these ancient fish. If you're planning a trip and need more specific locations or tips on techniques, feel free to ask, and I'd be happy to provide more tailored advice based on your destination.