You need to figure out how much air you need, and get the tank to suit. Granted there may be a limit to how much you can carry, so figure out what you need and get the closest size you can handle up to that point.
In wreck diving you need to calculate your air consumption at your intended depths, figure out your maximum bottom time (and back gas deco time if applicable) and then add 50% to that for emergencies. That is the size tank(s) you need (minimum).
Now about handling them
.I am 64 245 lbs, and have been a sheet-rocker in construction for 22 years. I am in pretty good shape (for the shape Im in).
I also dive the twin HP 130s because I have a .78 working sac rate and love long deep dives. I need the air. However, these things are still very hard to manage when climbing into a boat or up hill shore climbs after a dive. I have intentionally used them on even my shorter fun dives for the last 80 +/- dives (mostly anyway) just to get used to them, so they are second nature to carry. They are still a ***** to handle above water. (Although I can probably do cart wheels with my single 130 now).
Dont get an unnecessarily large set if you wont need them. Get tanks based on your air needs. Plus mine with a back plate weigh in at about 145 lbs dry when set up (I weighed them). That makes me fairly top heavy, and I need to keep them high enough for valve shut downs (another subject). This means lowering my weights (via weight and trim) to offset my trim.
Note: Air does have weight, and the difference between my full 130s and empty is a lot (cant remember exactly but you can find the info on the internet). I have to dive at least 10 lbs heavy at beginning, to ensure that I can stay down if the tanks are at 500 psi. I have to put the air to compensate for this in my BC (it would not be a good thing to put it in my drysuit). You now have to learn to manage the BC and the drysuit at the same time. You do get used to it, but it is something to think about. The bigger the tanks, the more this problem exists due to the difference in weight from full to empty.
Now if you do go for bigger tanks, and think you might not be able to swim them up, you may consider a double bladder wing. That is what I use. I have dual 95 lbs of lift. (You can only use one at a time). I keep the extra inflator hose tucked behind me ready to go in an emergency if the primary bladder fails. Your dry suit (if you use one) would also help in an emergency, but may not be sufficient as full redundancy to the BC. If you dont dive dry, then a dual bladder is very advisable (IMO) for redundancy.
Hope the extra 1-1/4 cents helps.
-Steve