For me personally, trams are right up there. Aside from the main issue of sharing the roads instead of having a dedicated line, they really make it easy to get from one part of a city to another, especially for wheelchair users. They’re usually as frequent as buses, but much faster. The stations are much more attractive compared to bus stops (on newer systems), and can really make an area feel much nicer IMO.
For those that have a bike, suburban and inter city rail is a strong second. The speed and ease of last mile mobility is what appeals to me the most. Recently took my bike across the country to my home city and it ended up being much faster than driving (by almost an hour) - the multimodal commute was pretty hefty, but lots of fun nonetheless.
Bike for sure, as I was still at school I did 100+km /week. I guess it stuck. Second is probably kayaking although it is seldomly actually useful transport. Then walking, and after that all manner of trains, then cars, then busses, and last planes. But honestly I just like being in transport to some extend so unless I’m dreading my destination I like them all.