I'm curious but are you living somewhere far from a place with a tropical climate?

In Australia pineapple on pizza is a really common thing. The only person I've ever met who didn't like pineapple on pizza just doesn't like pineapple at all in any context. Over here it is also pretty common to have pineapple on burgers.

My Canadian born girlfriend (who mostly grew up here) has told me that when she visited Canada at 14 and was shown a mango over there she didn't recognise it as a mango because it was so small and weirdly coloured compared to the ones we get here.

I'm beginning to think the objection to pineapple on pizza comes from people not having access to halfway decent pineapple

The contrasting taste of Pineapple and Ham does work well in my opinion.

Have you tried lemon (somewhat caramelized) and ham? :P

It's a question of ingredient quality. Most Hawaiian pizza is made with canned pineapple and thick-cut deli ham. Fresh pineapple and also any other pork aside from that ham is a big, big upgrade.

Yeah, that may have something to do with Hawaii as an island location, and what can easily be preserved, shipped, and stockpiled.

Though not strictly pizza Chris Bianco has lemon, rosemary and pecorino focaccia in his cookbook https://www.bakingsteel.com/blog/lemon-and-rosemary-focaccia

I've done mango, and it's pretty good. I could see lemon being nice. Dried Fig is also great on pizza.