Comet azur definitely still packs a punch, but it's not quite the instant-win button it used to be (especially since some recent tweaks to how it works). The real power comes from knowing when to use it - those big, slow bosses like erdtree avatars are practically begging to get blasted, while speedy ones like malenia will just dance right through it.

Here's something interesting - combining it with the cerulean hidden tear and cerulean hidden tear creates this absolutely bonkers 10-second window where you're basically channeling a star, and tossing on azur's glintstone crown makes it even nastier (though you'll burn through fp like crazy). The thing is, we've got some pretty spectacular alternatives now. Meteorite of astel absolutely demolishes groups if you can get close, and ranni's dark moon brings this nasty combo of magic debuff and frostbite that's particularly devastating against resistant enemies.

You might want to look into ancient dragons' lightning strike too - it's fantastic for breaking stance, though you'll need to invest in faith to make it work. The real key these days is flexibility, because different bosses need different approaches (some are practically built to counter specific strategies). Maybe worth keeping a backup plan ready, like how the blasphemous blade can absolutely carry you through magic-resistant encounters.

One last thing worth mentioning - some of the newer dlc bosses are pretty savvy about dodging continuous attacks, so you might want to mix things up rather than relying on any single approach.