I like all of the bard subclasses in the 2024 PHB.
Dance bards are going to eat through uses of Bardic Inspiration using Tandem Footwork but it's a strong ability and easy to apply. I like Inspiring Movement because it's a very tactical ability.
Lore bards seem to get a lot of being a bard more. More skills, more spells, more bonuses. The bonus skills are minor but it's still being better at 3 more skills, and Cutting Words is useful. Magical Discoveries is a bit weird because it can't actually be used for bard spells like Magical Secrets can, and it does get practically replaced by Magical Secrets later, but it's good at it's levels and it's always going to be more spells prepped which has it's uses. I like the changes to Peerless Skill because it applies to any skill check or attack roll, is an option triggered by a failure, and doesn't use the BI use if it still fails. Lore is hard on BI uses but so are Dance and Glamour bards.
Valor bards are still the classic bard in my mind. They have combat training, skill benefits, and strong magical abilities. Their BI dice are awarded to other PC's and are going to get used in typical ways. The AC is decent, they can be built for weapon combat, and they now mix magic and martial attacks better. They're a bard that's good at being a bard.
Glamour bard changes seem to hit all the right spots to streamline the college a bit. They gain 2 spells before Lore bards even if they don't get to choose them, and a 3rd when Lore bards gain their 2, and the spells align with the other Glamour bard abilities. All 3 of those spells are useful. Beguiling Magic let's the bard charm or frighten a target in addition to the spell cast and can be recharged with BI dice. Mantle of Inspiration grant thp but the real benefit is granting off-turn movement to many PC's at once. Mantle of Majesty allows for using Command as a bonus action without a spell slot and is worth the 3rd level spell slot to recharge. Unbreakable Majesty can stop a lot of attacks.
Glamour is focuses on enchantments and illusions, which is a bit of a pigeon-hole, but it meshes the college abilities with those spells rather well, IMO. I find spending BI uses to recharge Beguiling Magic and on Mantle of Inspiration to eat BI dice but those are worth it.
I still think the loss of Song of Rest, changes to Jack of all Trades, and slower high level spells known progression are overall a nerf to the class but it sure seems a lot more streamlined than it was in the base class and subclasses.
They all seem good to me for the purposes for which I would use them.