Will Ultimate FAQs make a GeneratePress site feel heavy?

The implementation decision should be based on the support workflow you need. Keep the category structure, display style, and enabled features focused. A site with only a few static questions may not need a dedicated FAQ system at all.