Why was the Galaxy class saucer separation ability so rarely used?
The Galaxy class starship was designed with the ability to separate the saucer from the stardrive section, so that the "floating city" part of the ship could be left somewhere safe while the rest of the ship galavants off to do something risky. We see this happen precisely once, in the season one episode Arsenal of Freedom. We also see saucer separation deployed for a handful of tactical and or emergency uses (such as against the Borg in The Best of Both Worlds, or to escape the breaching warp core in Generations).
So, this seems like a useful ability to have, and the Enterprise is constantly being sent into dangerous situations. Why not use this ability more frequently?
That's a fair point. The utility of the saucer as a separate craft doing different jobs is pretty limited though, which is another reason why we might not see it in day-to-day operations. There is only so much a 600m disc with no warp drive can accomplish on it's own.
It's the no warp thing that really limits its ability. The saucer can 1. limp back home. or 2. stay put while the rest of the ship does something risky and then hope they don't have to resort to number 1.
I could see the saucer section being left in orbit to assist with evacuations while the stardrive section "goes for help" but even this seems like a bit situational.
It's not just the lack of warp that presents a problem. It's the lack of power generation. If I remember correctly, and I'll admit I may be misremembering, but isn't the bulk of the Ent-D's energy generation done by the warp core as well? So if the saucer is separated, any heavy power use (i.e. the main phaser array, heavy transporter use, etc.) is going to require the saucer to eventually link back up to refresh it's power reserves lest they end up in a Voyager power rationing situation.
Edit: This same point is what drives me crazy when I see the separated warp nacelles in DSC. If the ship loses power for any reason, the nacelles are going to float away which just adds to the list of problems to solve when getting the ship back under way. Also, if there's a momentary power interruption to the beam emitters holding the nacelles in place, what's to stop them from launching off like warp-powered torpedoes?
To your comments about the floating nacelles - what's even supposed to be the point? I can't imagine how having nacelles detached offers that much of an advantage.
It might be big enough to work as a temporary small space station around a planet or just in some general area in need like a fleet in need of repairs and medical aid.