Whilst periods themselves are not really that much of a turn in for me. The type of sanitary product used however coil be a turn on in some circumstances .
From my experience with
N20 and to a lesser extent
R22. No matter what the underware selection on the night, the towel never looks flattering especially when it is haphazardly stuck on to what would otherwise be a sexy pair of knickers. A pad showing through the lacy front panel doesn't do much for me, nor do dark pubes stuck to a white towel that has been stuck on to the side of the woman's discarded panties.
The tampon in the other hand is inserted into the body and in certain circumstances might be regarded as a very wired kind of sex toy. Certainly sliding one out of a woman who had clearly finished her period was rather nice.
There is some circumstantial evidence that some guys like tampons too at these threads.
here and
here