He's unquestionably godlike. Has the potential to outplay people with higher BP depending on enemy comp. However he doesn't just fit into any team, and lacks utility tbh. So that is his downfall. The best team you can ever build is a sustain team that will keep him alive or revive him if he dies. I think his counterpart Kakazu is much better since he sustains, removes buffs, interrupts, has super armor, high damage, but lacks a DOT ability. As far as Deidara being used in CN, people use him but not as often. You would have to look in specific BP brackets to see him being used. People who are stronger typically run Angel Konan, Kisame, Edo Hiruzen, Shisui (pvp more so), Jonin Minato, Edo Tobirama. These ninjas are primarily what you will see the most and may always be used in current and future meta's in CN just because of how well rounded/ strong they are. You also have Kurama Naruto, Madara, Sasori edo, Ay, and Sasuke but they are ninjas you don't have to spend for unless you don't want to use seals to get them.