Numse

I haven't really explored other chemistries because bulkier was a no-go for me. But you also may want to look at discharge profiles. Lithium (LifePO4) have a nice linear discharge rate, so you get nice constant power until the end (think power tools: they work, they work, they work, the battery is dead). Also, if considering other chemistries, you need to also know the charging profile and determine if the MPPT can produce that profile to charge your batteries.

I believe it is worth it, but you will have to invest some of your time in research. You need to understand how to properly size your system. For example the MPPT is sized, not only to the specs of the solar panel array (or single panel in your case), but also to the nominal voltage of the battery bank (12V vs 24V). Then, if you want to use that power, you will need an inverter. It is all doable but all-in-one power stations are becoming cheaper and cheaper. You could look at refurbished or wait for sales. It's not much more than a DIY setup. If you do opt for DIY, I would use lithium batteries. Initial cost seems higher but they are ultimately cheaper and safer over time. There are several low-cost brands today that sell lithium close to led-acid prices (li-time, watt-cycle).