do you have a product, like some kind of paint that would go over smooth tile on a chimney surround that would rough it up so you can tile over it.

We recommend Mapei Eco Prim Grip to adhere tile over tile, and you may need a self-leveling compound to smooth low grouted joint areas.

No they don't have that but you can use a oil based primer to help the paint stick to the tile

You need to ask them

There is a product called Prim Grip that is for tiling over smooth surfaces