I am not the right person to reply to this, since I`m NOT a big fan of pineapple.
One I`ve tried lately is Live(Jennifer Lopez), and I thought the pineapple was very dominating. I think this one is a "fruit-cocktail"-scent... Two I like that have pineapple in them are Amuleti by Mariella Burani, and Sonia Rykiel. Also Eden(Cacharel) has a pineapplenote, so does Cool Water(Davidoff). One I have not tried is Envy Me (Gucci, 2004).