Upgrading a newer low-end bike vs buying a higher-end bike, what makes more sense?

I ask this partially for my own scenario but also wonder if there are some commonly known trends where certain items make sense to upgrade while others would be a waste of money on a lower-end bike compared to selling and buying a new bike. I'm new to road bikes so I didn't want to spend $4000 for...