A SEAL Plattoon (16-Men) will usually have several members with sniper training. Beside sending their personnel to other sniper courses the SEALs run their own courses which emphasize naval-specific operations.
Special Operations Forces (SOF) [the generic US term for all spec ops forces] usually have a high percentage of sniper-trained pesonnel. Just like LEO SWAT teams, they are also used for scouting and overwatch.
Modern SOF snipers have a range of weapons and sights. THey fit the weapon to the job.
I have a friend that I dive with once in awhile who’s son is a navy seal. After he got his Trident he went to sniper school. He told his dad “sniper school was the hardest thing he ever did.”