Looks like these are pulls out of 1U servers, could be great if you want something a little newer for pfSense in this guide. Would also work great for Plex QSV transcoding.
What is going on with the black plug(6pin molex?) hanging off the fan and also plugging into the board? Is it a 6 pin delivery for an add on card, maybe with an extender of some kind?
Still can’t tell what it is after looking at manual. It is notable that this board does not have the m.2 soldered. X11SSQ/-V has a m.2
Depends on what you decide to use it for. The CPU cooler should be adequate, but it might be loud. I’d take look to see if it’s a normal mounting system when you get it, before you decide to buy another cooler.