We'll start with the TLDR:
Having bad luck with cheap PL-259 connectors and want something that won't make me want to scream.
For my job, I've been soldering to DB-9 and DB-25 connectors for over 20 years. Have never had an issue. I bought some LMR-240 cable and some solder...