I am torn.
On one hand I am a huge fan of familiar and want them to be awesome.
On the other hand I like balance and a familiar is a first level feat that many classes and an ancestry can take.
Hopefully they will have option to be more awesome bu I imagine that this will come with the witch. The witch should have many class feat to have a better familiar (hopefully) and on top of that there will be an archetype called familiar master that should be good with it. I cross my fingers for more feats for familiar in general.
A familiar should be "bad" because indeed 90% of what it gives is the extra cantrips and spells. Making familiar good at doing things by themeselves can lead to a great action economy (see right now the multiple alchemist that lament that they feel they HAVE TO take a familiar for their quick alchemy. I think they otherreact but that's not the point). Action economy can be worth one or multiple feats by itself depending on the action so I don't think it should be on the base kit of a furball.
Right now the familiar is good for an alchemist and okayish for a mage (tend to be better if you GM allow you to use it creatively) but I am sure that in the future, with enough new feats, familiar will be able to be awesome if you sacrifice enough feats (like for animal companions)