Technically, any brand of CA will get the job done, but it comes down to personal preference as to how thick you need the product as well as how easy it will be to apply it.
I don't care for thin CA's (i.e. Crazy Glue brand) where being too thin makes it cure too fast.
When I glue tires, I put a thick line into the bead, press-pull-press which forces the glue to spread evenly across the bead to ensure 100% contact patch across the entire bead. Not only does this get CA on both surfaces when I briefly pull it away, it starts the cure process and acts in similar fashion to contact cement which increases the bonding strength to ensure you don't lose any tread during a race.
I recently won some thin CA glue in a raffle at a big race event last month and foolishly decided to use it, I could NOT do the pull-press method and sure enough those tires are ungluing on me
The ONLY brand I have grown to trust is what HeavyBag recommended above being LOCTITE brand which is a cross between medium-thick which gives me about 10-15 seconds of working time to properly set the bead.
The most important thing to me is the applicator where I switch between 18ga and 20ga metal tips which fit perfectly on the LOCTITE bottles:
https://www.amazon.com/gp/product/B07FSNQ7W1
https://www.amazon.com/gp/product/B07PZKQG3Y/
I kinda wish they made a 19ga where 20ga doesn't quite spread enough and 18ga wastes a little more product than I like, but I'd rather waste some product than have tires unglue on me!
***
Tire Prep is also VERY important where I use the following method:
1) Use the cylinder shape stone bit on rotary tool to scuff the beads of both the tire and wheel
2) Use Simple Green to clean both beads of tire and wheel