Can someone recommend a nice camera for me?

I’ve been really getting to photographing my coral a lot lately, but my camera is poop. Sooooo since christmas is right around the corner i was thinking now would be a nice time to get a new one. The main thing im concerned with, with the camera is its ability to take nice macro shots. I know their some really nice cameras out there for a ton of money, but id rather not go over the top. Can someone recommend me a nice camera that is at a more affordable price?