Is a sagging ceiling dangerous?
Yes. Drywall holds a lot of water before it fails, and a bellied ceiling can come down in one piece along with the insulation above it. Keep everyone out of the room, do not push or poke the sag, and have the water relieved at a chosen point by someone who can catch and drain it.
The instinct to make a small hole and let it drain is the right instinct done at the wrong time. Without a container, a drop cloth and somewhere for the water to go, a relief hole empties the cavity into the room and spreads the damage to the floor and the contents. Done properly it is a controlled operation that takes a few minutes.
The other hazard in the same ceiling is electrical. Light fittings, fans and alarms sit in the plane that is holding the water, and a fitting that is dripping has water in its housing. Switch the circuit off at the panel from a dry position, and do not operate the light to see whether it still works.
Why is the stain not under the leak?
Water entering a roof or a floor assembly runs along the framing, over the insulation and across the back of the board until it reaches a joint, a fixing or a fitting. It leaves at the first weakness it meets rather than the nearest point below the entry. The stain marks the exit, not the source.
That is why the inspection goes up rather than along. From inside an attic you can usually see the track: a darkened line on a rafter, matted insulation, a rust mark on a nail, a stain on the top of the ceiling board that is larger than the one visible from below. Those tell you where to look on the roof.
Can a stained ceiling just be painted over?
Not until the cavity is dry and the source has been stopped. Paint over wet board traps moisture against it, the stain bleeds back through, and anything growing on the insulation above keeps growing. Once readings confirm the assembly is dry and the leak is fixed, repair and redecoration are straightforward.
Where board has been wet enough to lose its strength, patching is the wrong repair and a section is cut out and replaced. That sounds like more work and is usually less, because a soft ceiling patched in place tends to sag again at the joint. The cut is made along the framing so the repair has something to fix to.
What changes what this job costs here?
The size of the wet area above the ceiling, how much insulation and board have to come out, the height and access of the room, and whether the source is a roof, a plumbing run or an upstairs floor. Multiple floors or units add to it. The scope and price are explained and approved before work starts.
The stain is not the measure; the wet cavity is, and finding its extent is the first hour of the job. A single damp patch under a bathroom with a defined source is at one end of the range. A long wet track above a hallway ceiling, with matted insulation along several joist bays and water into the wall below it, is at the other.
Access adds to it in plain ways. A high ceiling, a stairwell void or a vaulted assembly with no attic above it all take longer to open, dry and reinstate than a standard eight-foot ceiling with a hatch nearby. An upstairs floor that has to be dried at the same time as the ceiling below means two drying environments instead of one. None of it is quotable from a photograph, which is why you get a figure after a visit, in writing, before anything is cut.
What should I do in the first hour?
Move people and belongings out from under it, put down containers and something to protect the floor, and switch off the circuit for any light or fan in that ceiling. If you can safely stop the water at a stop valve or by keeping rain out, do that. Then call. Do not push on the sag.
Photograph the ceiling from the doorway and close up, including any sag, before anything is moved or relieved. Note the date and the weather, because whether the stain grows with rain or with use of an upstairs bathroom is often what identifies the source. Keep the photographs with your other claim material.