My DD did FoP at park closing - I timed for them to get into line at 9:26pm right before park close at 9:30pm. I didn't want them to get in line too early. It should have been just a 30 min wait but tech difficulties slowed things down so it ended up being a 45 min wait. Posted wait time was 90 mins.
If you want to go earlier in the evening, I would suggest go right about when RoL starts as that does suck a lot of people away or right at closing. Warning though: We also did one ride using FP right before RoL started and tech difficulties meant that even with FP, it was about a 30 min wait. So I have no idea if that timing strategy works.
The ride is worth it. Don't leave Disney without riding it.