The core story is just... So dumb. And the dialogue between genuinely any two characters that doesn't involve the titular Pikachu made me real uncomfortable.
But I adore the world that holds it up. Watching Detective Pikachu was like drinking hot chocolate by the campfire in winter. Even my roommate who had to be dragged to the thing kicking and screaming ended up having a wholesome good time.
Final rating:★★★ - I liked it. Would personally recommend you give it a go.