Cartagena is much more beautiful, Bogotá not so much. Bogotá is a cool city, but I would always choose Cartagena.
Cartagena has the sea, islands nearby and its walled city. As a tourist, Cartagena is much better to visit than Bogotá. Bogotá has the Salt Cathedral and other sights nearby.
We recommend to read our full guide best hostels in Bogota for more information.