I don’t want to detract anything from this tram photo, but I also know that with all the content floating around in the internet these days it’s easy to build unrealistic tram expectations.
I think this is two trams, each on their own line. Notice how the roof line steps down and the window reflections seem to change halfway through. I think they’re just very conveniently aligned for the photo to make it look like one double length tram.
If you’re just looking to get started with 3d modeling, it’s hard to beat Blender. At the cost of free, it’s by far the most affordable way to dip your toes in some modeling tools.
For many workflows it’s world class. If you plan to do more organic forms or don’t need technical precision, then it’s very competitive or preferable to paid software.
You might find it lacking if you plan to do parametric or technical CAD-style modeling. Even then, I think Blender can be a low cost way to learn what you want in your software before investing in more specialized software. You’ll learn enough of the modeling basics to more fluently navigate what other software provides.