I think we've all been there a time or two. I have a few UFOs myself right now.... and I plan to put numbers on 5 of them.... I'm not going to pick which ones, just the top 5 projects. Then, I'm going to have my DH or DS pick a number from 1 to 5. Whichever number they choose will be the one I work on.... no backing out or whining about which one. Just do it..... muddle through if necessary. The goal will be to work on it till done. Then, I'll pick the next one, etc. Sometimes I just have to force myself to work on something but that's okay.
One way I've gotten myself to work on a project that I'm not excited about is to bargain with my time. I tell myself that I will work for 2 hours and then I get 30 minutes to do something I'm really wanting to do. Then, I just repeat the 2 hour, 30 minute cycle till I either get it done or till I've reached the point where I'm excited to get it finished. I find that I'm always more excited to finish the closer to done I get.
Good luck... let us know what works for you.