Well here's my humble experience:
Artin is a wonderful book, with lots of insight, which is it's strong point. I haven't read Dummit & Foote, but it does cover more topics, and is in a more standard format. Fraleigh is a weaker book than both Artin and D&F. I own the third and seventh editions but I never read them, I don't like the way you're treated like a baby. Fraleigh does have some answers and hints at the back (3rd edition does, not sure about 7th ed.) Another good algebra book is Birkhoff & Maclane, I own the first edition, and it is not as difficult as Artin, but not as simple as Fraleigh, but provides good motivation for the topics and some hints/answers, but the questions are generally quite simple.
I own Simmons, and it doesn't cover all the usual topics one would cover in a real anaysis book like Rudin, it does cover some, but not all. It's sort of like a mixture of real analysis and topology and functional analysis I think. Munkres is a straight topology book aimed at undergrads or 1st year grad students.
Tao's books on real analysis are quite lenghty, which is why I never read them. Rudin is too dry for my liking, but some people love it. I much prefer Pugh's book "Real Mathematical Analysis" which is at a similar level to Rudin, but I believe much better.
For linear algebra I really like Axler "Linear Algebra Done Right" and Hoffman and Kunze. Ok I haven't read any other linear algebra books (besides my course notes), but I still really like those two books. I like Axler's determinant free approach, which I think helped me understand linear algebra more. Hoffman & Kunze is just a legendary book.