Thoughts on running a node and indexer using a Raspberry Pi 4 8GB RAM and 4TB HDD

HDD will definitely not work for the mainnet data folder.
It may or may not work for the indexer but I would not recommend it.