Hi,
This is most commonly used in server and datacenters, for normal user it is better to leave it on default..
And yes, once you'll enable it on one device and other end does not support it - you'll create headache for yourself.
Basically - jumbo frame is a data packet with more than normal amount of data in it. If other device see it - it will either discard it as malformed, or it will divide it into smaller packets and generate new traffic that will be small enough for it to process. But in proces of generating new packets - you will lose time and effort that requires to handle division of packet into smaller chunks and also on other end you will also have to combine those new packets into original one and process it only after that is done.
But - if you have devices capable on either end to handle it and both will get configured same way - in home environment you don't have any real benefit, but will also not run into any problems.
Both ends just need matching config.