I have been doing a lot of testing between RPi models and USB drives (SSD vs spinning) for setting up nodes and have come to the following and
very obvious conclusions.
1) Cheap generic USB to SATA connectors suck. Seriously, there is a difference between the better brands (Startec / SYBA) and the generic off brand ones.
Now, I did not check many but I did check a bunch and on the same hardware the sync time did go up a lot with the cheap cables.
2) Cheap SSDs suck. Although there was not as big a difference as with the USB to SATA adapters there was a difference. The worst off brand SSD drive was actually slower then the best spinning drive. But in it's defense it was LESS money the the spinning dive so there is that.
3) There is not much a difference between the RPi4 with 2GB ram and 4GB ram. There is a big difference between 1 and 2 GB
4) The RPi4 is MUCH faster then the RPi3 IF YOU COOL IT. Initial sync will thermal throttle the RPi4 so you do some form of cooling on it.
5) Spend the extra few bucks and get a real power supply. Seriously, the cheap "2.1 Amp" models do not do 2.1 Amps and the cheap 4 Amp models don't even come close to it.
6) Somewhere in one of the RPi threads (might even be this one) I mentioned that some cheap cases with cooling are so badly made that they do not even make contact with the chips and you need to add a shim to actively cool. This is still true.
7) Get a real SD card that has a longer rated read / write life:
https://www.amazon.com/gp/product/B00V5Q1N1I/ref=ppx_yo_dt_b_asin_title_o07_s00?ie=UTF8&psc=1They do matter. It's not that much more then the generic ones. Yes they are a bit slower, but you have the blockchain and most of the read / writes going to the external drive so the speed it not as important.
I guess it's kind of obvious, but it really shows up here, going cheap will cost you time and grief.
Also, as others have said getting a $100 PC off of eBay will be much better then doing a RPi build. But not as much as a challenging, learning, experience.
My ideal setup now for doing something like this (for now) would be a RPi4 with 2GB ram, some kind of case with active cooling and the Samsung 512GB external SSD drive along with with official RPi 3A power supply.
-Dave