Casiquire, as a trained classical bassist, I do not agree with your comments in total. In one sense I do think they are correct in that in terms of "Hollywood" the techniques are not used as much. However, overall, in the orchestral literature, legato, in particular, is critical. In terms of a large orchestra, the articulations of the bass section in AP strings are lacking. OTOH, one of the reasons I really appreciate VSL is that for orchestra/chamber/solo the bass is complete.
Note that when shifting positions on the bass, like the other stringed instruments, the string is kept pressed against the fingerboard. So yes, it takes more physical strength to play the bass, and the bass certainly is less agile.
In general, some composers tended to write extensive bass parts, while others tended to mostly ignore it.