I can’t speak to all jurisdictions, but in Florida there are laws that prescribe how a search warrant can be executed.
For one, it must be served by the officer who obtained the warrant (although he or she is allowed to have back up with them).
[QUOTE=Fl. Stat. 933.08]
The search warrant shall in all cases be served by any of the officers mentioned in its direction, but by no other person except in aid of the officer requiring it, said officer being present and acting in its execution.
[/QUOTE]
When serving the warrant, the officer is required to give a copy of the warrant to the occupant, and is required to give an inventory list to the occupant when they take stuff.
[QUOTE=Fl. Stat. 933.11]
All search warrants shall be issued in duplicate. The duplicate shall be delivered to the officer with the original warrant, and when the officer serves the warrant, he or she shall deliver a copy to the person named in the warrant, or in his or her absence to some person in charge of, or living on the premises. When property is taken under the warrant the officer shall deliver to such person a written inventory of the property taken and receipt for the same, specifying the same in detail, and if no person is found in possession of the premises where such property is found, shall leave the said receipt on the premises.
[/QUOTE]
They can serve it at night, or on Sunday, but that requires authorization from the judge issuing the warrant.
[QUOTE=Fl. Stat. 933.10 & 933.101]
A search warrant issued under this chapter may, if expressly authorized in such warrant by the judge, be executed by being served either in the daytime or in the nighttime, as the exigencies of the occasion may demand or require.
A search warrant may be executed by being served on Sunday, if expressly authorized in such warrant by the judge.
[/QUOTE]
Once the warrant is issued and is being served, the officers have wide latitude in making the search, but they first need to announce what right they have to make a search.
[QUOTE=Fl. Stat. 933.09]
The officer may break open any outer door, inner door or window of a house, or any part of a house or anything therein, to execute the warrant, if after due notice of the officer’s authority and purpose he or she is refused admittance to said house or access to anything therein.
[/QUOTE]
Refusing to cooperate with the search is a crime
[QUOTE=Fl. Stat. 933.15]
Whoever shall knowingly and willfully obstruct, resist, or oppose any officer or person aiding such officer, in serving or attempting to serve or execute any search warrant, or shall assault, beat or wound any person or officer, or his or her deputies or assistants, knowing him or her to be such an officer or person so authorized, shall be guilty of a misdemeanor of the first degree
[/QUOTE]
But obtaining a search warrant under false pretenses is also a crime, as is exceeding the scope of a lawful warrant.
[QUOTE=Fl. Stat. 933.16 & 933.17]
Any person who maliciously and without probable cause procures a search warrant to be issued and executed shall be guilty of a misdemeanor of the first degree
Any officer who in executing a search warrant willfully exceeds his or her authority or exercises it with unnecessary severity, shall be guilty of a misdemeanor of the second degree
[/QUOTE]
And, if property is improperly obtained, it can be returned, but only by court order (although I didn’t quote the lists of exceptions and nuances; basically, gambling equipment, intoxicating liquors, and firearms are presumed to be improperly held, and it is on the person seeking their return to show that they are proper)
[QUOTE=Fl. Stat. 933.14]
If it appears to the judge before whom the warrant is returned that the property or papers taken are not the same as that described in the warrant, or that there is no probable cause for believing the existence of the grounds upon which the warrant was issued, or if it appears to the judge before whom any property is returned that the property was secured by an “unreasonable” search, the judge may order a return of the property taken.
[/QUOTE]
…
TL/DR
If a cop shows up to execute a search warrant, you are entitled to a copy of the warrant and you are entitled to an inventory list of the stuff that is taken. But you can’t interfere. If you wish to fight the taking of your stuff, you need to go to court. If the court finds that the search warrant was obtained maliciously, or the cop exceeded their authority, they can get into trouble. And if the stuff has nothing to do with the crime they are investigating, or is not itself contraband, you can get it returned.