Are the USA Navy Seals really as bada ss as Casey Ryback or is he just fiction?

They shoot unarmed people and lose their helicopter and do such a bad job that their President has to lie for them.