I'm probably getting one for desktop use, but I'm also curious for other use cases, what's the power usage like? while idle or doing high frame rate video?

Great! The board uses about 1-1.5W under continuous use with no OS/kernel power optimizations.