The content migration situation between a development environment, staging and production is just silly.

I've written database diffing and bulk replace tools just to make this simpler and I still have ways to go before it becomes anywhere near sane.

I honestly think WordPress has cognitohazardous effects on developers, after enough exposure you start normalising the most insane development practises.