Don't forget which ever way you go that typically tank loads are 80% of the tank size. So a 500G holds 400G more or less (it all depends on the placement of the tank vent which can vary slightly tank to tank).
Based on everything you have mentioned I think you would be better off with a fixed auto transfer type system. It will be a one and done install, the cabinets do a fair job at sound suppression and best of all the misses does not ever have to do anything in the event of a power outage. The only down sides have been mentioned - more up front cost.
Because you described a situation where your homes annual propane usage is not too large you could always elect to put in one large tank (500 or preferably a 1000G - buried or above ground) and run everything off the single tank.
I have 2 1000G tanks - one for the house and one for the Gen and the advantage (also previously mentioned) is the ability to fill propane just once a year when summer prices are low.
My tanks are purchased but I have not had any issues purchasing propane form whomever is cheapest. Many companies will try the old, "we have to come out and pressure test the tanks before we fill them" to which I reply not on my $ you don't. It's mostly a crock, all they need to do is check the tank dates to make sure they are within the revert window.
Anyway good luck whichever way you go!