I love fresh pineapple but often use tinned in cooking.
Also, many places where you buy fruit, have awful pineapples, so unless I do my shopping at a "good" and expensive shop which I go to every few weeks - their pineapples are mostly sweet and last for weeks however I would rarely buy one from a supermarket or a cheap fruit shop, of which there are many. They also often have a lot of brown marks which my expensive shop does not!
I just use tinned for cooking as it is so much easier than buying a whole pineapple, when I may only need a small amount. Then you have to carry it home and cut it up. Way too much work. If I was making a fruit platter I would use fresh, but otherwise, tinned is a great alternative.
mainly used tinned, the supermarkets now sell pineapples minus their leaves so do not buy ,have not tried these as they look awful so am doubtful if they are any good, will only buy if leaves are still attached .