Loss is pretty important, but it's not the only thing to consider.
Firstly keep in mind while all RG-6 (or any other RG-*) is of similar physical dimensions and should be compatible with the same connectors, the quality of a particular cable can vary a lot. The loss you'll see quoted in tables typically assume a high-quality cable from a major manufacturer like Times Microwave, Belden, or CommScope. There are however a great many no-name manufacturers making much lower quality cable that will have much higher loss.
So to get an accurate number on loss, you want to find the manufacturer's datasheet. If you find some cheap cable on Ebay or Amazon and there's no datasheet, the cable will probably have higher loss, as its cheaply made. This is especially true for RG-59 and RG-6, which are aimed at nontechnical consumers wanting to put CATV cabling in their home.
Besides loss, coax has a characteristic impedance. Most coax is either 50 ohms or 75 ohms. RG-58 is 50 ohms, RG-59 and RG-6 are 75 ohms.
CATV and video applications conventionally use 75 ohm. Ham and other radio applications usually use 50 ohms.
You can use 75 ohm cable with radio equipment. In fact it can be quite a good match for a dipole, which has a feedpoint impedance around 75 ohms. Ideally you want to match the feedline to the antenna's feedpoint impedance, thus minimizing SWR loss. But you must also ensure the impedance seen by your radio, which is a function of the antenna impedance, feedline characteristic impedance, and feedline length, is within your radio's specification, or use a tuner or matching network.
On the other hand, 50 ohm coax, with a 50 ohm antenna, will work without a tuner with any modern radio.
You might also want to consider connector availability. Because RG-59 and RG-6 are used predominately for CATV, you will probably have a very hard time finding anything but an F connector for them. This means you will also need adapters to make any use of the cable.