I used to go to Lords and The Oval when I lived in London too. I was close to Lords and would also watch Middlesex when they played there but it was a miserable experience with most of the ground empty. England matches were fantastic though.
I totally agree that The Oval is the better ground though for all formats but ODIs have always been my favourites there.
Side note: my favourite ground though is Trent Bridge. Love watching cricket there. Sadly, Sophia Gardens has lost some of its soul for me and I haven't renewed my membership since the pandemic.