There are a lot of very nice custom tram assets, a lot of which also don't completely break the mechanic by adding way too much passengers.
A personal favorite, but not entirely appropriate: https://steamcommunity.com/workshop/filedetails/?id=636670836
Or this one:
https://steamcommunity.com/sharedfiles/filedetails/?id=636509925
I feel like this is a small change that makes a lot of difference. I feel it in my city how much impact seeing sensible public transport assets makes, and would love to see some in Clearwater.