For me that was the first ending I got, Rogue's path followed by the Sun. I felt like absolute shit afterwards personally. I took Johnny's offer because I was appealed by the idea of redemption, but instead he dragged Rogue down with him one last time. And then in Path Of Glory V had learned nothing, discarded all the character growth and ignored every lesson to instead let Night City consume her like it does everyone else that fails to realize it's a festering swamp you must leave behind at all costs. That's why the two endings that have a positive undertone - The Star and Temperance - involve the main character leaving Night City behind.