Of course you can add textures by merging images. There probably are tutorials, but it’s not really difficult to imagine how it could be done.
A fairly simple method:
- Find or take a photo of real lips
- Create a texture by using the high pass filter
Erase everything except the lips
Scale and position the texture over the lips
Set the layer blending mode to Overlay
Note: If the lips don’t quite match/align, you could use the liquify filter to distort them to fit.
Here’s an example showing steps 4 to 5. The result is quite subtle, which is probably key to not making it look too fake.