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.
I have a family car, road bike, ebike and escooter. I really like my escooter the most for traveling around by myself, especially so I can jump on a train or bus, or even get a taxi if needed BUT they are still illegal here so I got pulled over by the police (I wasn’t riding like an idiot so they let me off with a warning) and all the trains and buses have banned them so it’s now useless. They never made them legal so we only have dangerous cheap ones. We could have legalised them like we did with ebikes and would have tackled this problem but only young or poor people use them so no chance. I love my ebike too but prefer the e scooter unless I’m going shopping or much longer trips without getting public transport. My road bike is for cycling trips in nice weather.