Will the collagen booster also help improve skin texture?

I am writing to ask if collagen boosters help improve skin texture. I don't have severe acne or large scars, but when viewed up close, the surface doesn't look smooth and appears slightly rough. It particularly bothers me because when I apply foundation, it feels like it settles into the texture rather than creating a clean finish.

When I exfoliate, my skin feels fine for a while, but after a few days, it becomes dry and sensitive again, so I am currently looking into other skincare products. Collagen boosters seem to be well-known for improving elasticity, but can I expect them to be effective for skin texture or fine lines that look like thin layers of skin are breaking down?

I am also curious whether receiving a collagen booster makes the skin look instantly radiant or if it feels like it gradually plumps up over time.

I would also like to know how many sessions are usually required to see results from a collagen booster. Rather than drastic changes, I am hoping for just better makeup application and my skin to look less rough.