Do you have a certain brand or type I should get that's better then the rest?
Well, Clear Gorilla Glue is quite strong, and being clear has the advantage of not showing too much. But it's also a bit runny, and does NOT fill significant gaps.
The strength and versatility you have come to expect from Gorilla Glue is now available in an easy to use, crystal clear, non-foaming formula. Clear Gorilla Glue is incredibly strong and is ideal for indoor and outdoor applications and bonds virtually everything.
www.gorillatough.com
I find it useful for stuff like this, and if the tile to trim fit is good, it might work, but I doubt it would work around grout lines.
PL Premium Max is likely to stick almost as well, but this is a construction adhesive, so it IS gap filling.
Our strongest, most durable construction adhesive
www.loctiteproducts.com
Unlike most construction adhesives that cure to a "tire" hard consistency, this cures more like a "bowling ball". It is a dark-ish grey that will yellow a bit when exposed to sunlight.
Cleanup of both of these urethane adhesives is pretty difficult. Similar to 3M 5200 (a similar product that cures white that might also work).