Does Ultimate FAQs only make sense for large sites?

No. Smaller sites can benefit too, especially when they want cleaner editing and room to grow without rebuilding the FAQ structure later.