Thank you everyone for some very thorough answers! I've been properly scared away from the rotary buffer for sure now I'm going to do some comparing on the different DA buffers and see if I can't get a nice kit like you linked maxcichon. You probably saved me from burning a hole in my paint for which I'm eternally grateful!

I'll post some before and after pictures on whatever model I get.. cannot wait to get started!