I played a lore bard in BG3, and recently played a wild magic sorcerer at the tabletop; but I should point out I've never played a wizard. As I understand it both classes has fewer spells available, and they don't prepare spells daily so they always keep the same ones.
Sorcerer is really made by metamagic, which I used all the time. I think my main ones were Careful Spell (allows anyone I choose to auto-pass saves) and Distant Spell (doubles the distance, minimum 30ft). He cast a lot of distant Shocking Grasps. The sorcerer spell list is quite biased towards shooty damage spells, and limited in other areas.
Bard is more of a mixed class, so spellcasting is just one part of it with other abilities being quite separate, like bardic inspiration and the many extra skills. Bards are great all-rounder characters - maybe not as good a specialised class, but they can hold their own in a lot of areas. Mine was decent at pretty much anything except for combat, although she kept at the back enough that she was usually the only one unharmed after each battle. I noticed this after giving her the feat that lets you fully heal on a short rest.
