Why does selecting a file in WinSCP not work as I expect (that is, in the normal MS Windows way)?

You probably use Norton Commander-style interface. Selecting files in this interface is same as in Norton Command file manager. If you prefer Explorer-style switch to Explorer interface. You may also enable Explorer-style file selection even in Norton Commander-style interface.

Selection method of Norton Commander mode gives an advanced ability of selection and focus to be different.