My experience has greatly improved over the past few years. I use Monzo. I used to use Yolt to aggregate a couple of bank accounts and credit cards but Monzo offers that as part of their Monzo Plus accounts. It gives me a consolidated view of my spending.
I'm not really sure what else I'd want from Open Banking.