Load Forecasting for Households and Energy Communities: Are Deep Learning Models Worth the Effort?