Welcome to genvibe!
There's a thread on
replacing lights behind radio LCD that's not too difficult, but that only solves one part of the problem.
I haven't found a good way to add an AUX port to the factory radio. There's one tweak that involves putting a switched input jack between the CD output and the radio's internal amp, but the AUX in audio is low volume, and you have to have a CD spinning to make it work, I tried that, wasn't very happy with the results.
I swapped in a radio from an 03 Matrix that had a cassette, but eventually it stopped working well. They were an option in early Matrixes, never offered in Vibes, and there used to be limited supply, I expect they are a lot harder to find these days.
My best luck with the stock radio was to use a bluetooth FM transmitter.
I think if I had to do it over, I'd probably go with an aftermarket radio, with AUX in and bluetooth. AND Android Auto.
At least in the 2003-2008 Vibes, there is nothing else that goes through the radio. In other GM cars of the same years, the radios talked on a data bus with other car components, for things like door ajar and seatbelt warning beeps, as well as logic that required the radio be set up to match the rest of the car as an antitheft tool. (in Vibes the beeps come from a buzzer on the back of the instrument cluster) Since Vibes were sisters of Toyota Matrix, and Toyota didn't implement the GM data bus, the radios used in Vibes look like other GM radios, but have no support or need for the data bus. THis makes it pretty straight forward to go aftermarket, you just need the right wiring mounting adapter. Likely an antenna adapter too.
If you go aftermarket, one wiring tip to keep in mind is that the base of the roof antenna has a powered amplifier in it, the power for this comes from the head unit.