different plate boundaries occur when continental crust plates collide .This produces the highest mountains( like the Himalayas and Acancagua ), along with som really violent volcanics. When one of the plates is a marine crust, it usually gets subducted more easily and taps into magma fields as it remelts. These form unique volcanoes in the "Ring of Fire"
Transform plate boundaries (like San Andreas) actually form more water channels than they do any mountains. San Andreas has some low hills that are constantly being recyccled as their sediments are not durable. Then , if you find a LIDAR map of San Andreas , you can see streams debauching into the central core of the fault boundary and theres usually a growing water channel being formed (This presages the ultimate fate of San Francisco to become an island arc system..
The actual landform building is more a result of the erosion of the whole event than just "pushing the load upward"
Himalayas and Acancagua wouldnt be as spectacularly craggy without erosion and Ice sculpture
Transform plate boundaries are about the only ones that really dont deliver neat mountain ranges though (except for divergent boundaries and these are obviously "pulling away" from each other. We call them "trailing edge" plate boundaries. (Think of warm sandy beaches and broad wide continental slopes like the Atlantic coasts of US and Mexico.
There are all kinds of special cases like the Panama Isthmus, Karabougos, Sund sea and undersea plate collisions and seamounts where the volcanoes form along the sides of plates and then are quickly eroded to form island chains out in the ocean.