I haven’t been out to DL yet (first visit this November!) but I recently watched a video review of Paradise Pier and the reviewer rated it as “perfectly fine” but definitely not their first choice. Would stay again - clean, quiet, needed updating - but wouldn’t stay there as a choice more as if it were their only option for onsite. The rooms looked okay to me, but I’m not sure it would be worth blowing up a bunch of DVC points over it.
Meanwhile DCH is top rated with nearly everyone, DL Hotel a close second (and if you’re a Disney historian, is the original Disney hotel).
A better option would be to rent the points you’d burn up with any of these hotels and pay the cash price for the room, no matter which option you chose.