It really depends on what you're looking for out of a bird as well as you as an individual. Both Macs and AGS are intelligent. To my understanding, AGs tend to be a bit more timid and MACs a bit more "velcro-bird-ish". A lot of people really find the idea of a "lap bird" very appealing and well cared for macaws certainly have a reputation for being just that. They don't call them "mush Macs" for nothing

Both would need large cages, a macaw a bit larger than a AG, so consider your home and how much room you really have to include a cage, a play stand etc... To my understanding, if you are limited on room, TAGs have slightly smaller housing requirements than CAGs. There is also several species of mini-macaws to consider as well, so it's not just the big guys you have to choose from! I'd also recommend putting in some time at an avian shelter/rescue and get to know some macaws and AGs. See how loud they are in person, how you feel around larger birds, and if you're lucky, you may even connect with a bird up for adoption in need of a loving home

There are so many out there waiting to be adopted (my zon is a rescue and he is a character and a half, love my boy

).
On a personal note, I personally prefer and feel most confident around a medium-large bird and find the ginormous XL macaws a tad too big for my taste/a bit intimidating (and I grew up with parrots). I have been bitten by my fair share of med-large birds, including having been sliced to the bone by a small G2 and taken several facial bites over the years. I know I personally do not wish to be bitten by any avian with a beak 2X the size of the birds I've been bitten by! And bite they will! No owner of large parrots doesn't get bitten on occasion. Even a AG can inflict a nasty bite, so I'm not just singling out macaws. Once you get out of conure size range, you get into birds big enough to do serious damage that could require an ER visit or even reconstructive surgery. Of course, a happy and well adjusted parrot doesn't just bite for no reason, but at some point in your lifelong relationship wth your bird, every parrot owner gets bit. It's an important factor to consider!