Being retired is a plus. You have a good shot at achieving the necessary: good prep, patience and perseverance to end up with a low budget paint job.
I have had some good rattle can results, but they are fragile and the 1st chip is always devastating. Fortunately, it happens soon after completion and there us usually a partial can left that's still good for touch-ups. Once over the 1st damage hurdle, enjoy your results.
Realistically, if you want a really good, long lasting but low cost paint job, use a good, local powder coat shop that has bike experience. Lately, a thorough clean, polish and touch up of the original paint seems more attractive to me. Don