FPKM, FPKM-UQ, TPM or counts: How do I know which kind of unit should I use?
Type of data you need depends on the downstream applications and since you would like to carry out DEA with DESeq2, you would need raw counts (non-normalized).
There are many ways to import/download TCGA data, one such tool, the TCGAbiolinks package gives a nice interface for not only downloading the read count (or pre-processed) data but also associated clinical data.