If I can should I finance an Acura?

So my current car which is a 2015 Nissan Altima is having problems, the transmission is fucked. No surprise there but now I plan on fixing that cause I'ma need to regardless but instead of keeping the car after my and mom suggested I trade it in and put that towards financing a new car. Which isn't a bad idea I was looking at sum cars and I want something nice but reliable and I did come across a few Acura models that a high on reliability and not to expensive if my trade value and down payment are good and I've got ok credit for my age. My friend thinks it's a bad idea but from what I've looked up these cars aren't pricey when it comes to maintenance and are reliable and nice cars. But should I just get a Honda or would it not be a bad investment to get the Acura?
If I can should I finance an Acura?
Post Opinion