The 4th Amendment guards against unreasonable searches and seizures, and was originally designed as a response to the controversial writs of assistance (a type of general search warrant) I too believe in the 4th amendment. I believe we are talking about legal warrants here. I also believe that if your child had to walk by a crack house to and from school everyday, you might just have a different few on those type of raids.
[Amendment IV]
The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no Warrants shall issue, but upon probable cause, supported by Oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized.
Breaking down my door on a no knock sounds very unreasonable to me. Yes. of course the warrents are legal, that doesn't mean they are constitutional in my view (Same as many of our thoughts on 2A Laws).
My son does ride by a crack house on his way to school. As a matter of fact I live near one. We are working on getting the problem solved. How? The neighbors and I are on a constant watch, taking pictures and license plate numbers, etc. We are also resolved in the idea that a midnight raid is NOT the way to handle it. Too dangerous for everyone.
Have you ever seen this map?
http://www.cato.org/raidmap/