I did find one that sold hourly consultations and she was really helpful at confirming my plan and that another situation I may have gotten myself into was not a good deal for me.
I say all of this because $500-1000 for a fee-only advisor is something I literally could not find. Additionally, advisors I researched have minimums in the hundreds of thousands range.
I ended up following bogleheads methodology and I think I'll be happy. It's still pretty new so no real data yet.