I would interested in hearing examples of software that is a breeze to self host and terrible to self host. And most importantly, why? What can software devs do

I would interested in hearing examples of software that is a breeze to self host and terrible to self host. And most importantly, why? What can software devs do to make something a breeze? And what should they avoid? Thanks.