For me when something is written in past tense it feels like it is told by someone at a later time, and I used that early in my writing I think, but after I read some stories in present tense those felt so much more alive and vibrant and urgent, like I was there at the very moment, not sometime later, so I adopted that after I felt that way about it. Same for why I want first person, it is more intense, you are inside a character, second person is clunky though, I don't know why, but it feels like agency is taken away from you there. Though it can be particularly hot when role playing to have each player when it is their turn have their main character be I (first person) and your main character or the main target of their actions be you (second person) that becomes more intimate, though most people are not really comfortable writing that way. I also know some people who said it was too intense and uncomfortable and scary to write in present tense and first person. It makes a lot of sense if that is them retelling either some event that happened to them or something inspired by that, I notice that myself sometimes when I am telling about some past bad things, I layer distancing language into what I say to sort of make it less about me for some reason, I even sometimes refer to myself in third person then.
Let me make it clear that although I have a strong preference I can enjoy stories written in other points of view and tempuses.
As for the more exotic tempuses those can be fun to use with time travellers:
"You will have ordered this potion in a year's time and asked me to deliver it to you now, you will pay for it in the future not now." - Iswas Willbe (a lich who's phylactery is time itself, and he/it is a time traveller, his name is rather silly but also true in the setting I created that he/it is in: he Is, he Was, he Will Be

)
Or even more complex things, I think hitchhikers guide to the galaxy has some fun ones and a few other stories as well

Though if you write time travel stories from a first person point of view you probably need those less, only if you need characters to explain things
Anyway that is my two cents.