I want to transition away from Ubuntu.
But I'm not sure if I should get debian with KDE or Gnome. Or if I should try arch based Manjaro.
Most apps I care about are .deb packaged. How could I install them on an arch based system from the developers site directly, if even possible? 

 Chances are there's an Arch version of the package you want.