Almost all silver will shine nicely, but we also consider the hardness of the parent metal.
Fine silver is fairly soft. Shines readily, but also scratches easily. As noted above, it does not tarnish near as quickly as sterling or coin silver. We label it as ".999 fine", but will consider it as 100% silver - Ag on the Periodic Table.
Sterling is, by definition, 92.5% AG, and it's alloy can change a little, but basically it is alloyed with Copper. Pretty durable, reasonably hard, thus it's use a table ware and for trophies, etc. Somewhere on it, if from a professional source, it will be stamped as ".925" or as "Sterling". Polishes nicely, takes a high shine, it fairly scratch resistant (NOT scratch proof!). It also tarnishes fairly quickly, but there are a number of polishes that quickly remove the tarnish.
Coin silver is usually 90%, but can vary down to 50%. It can be very hard, depending on the alloy. It takes and retains a polish easily. Not as easily formed as Sterling. Usually NOT marked as to percentage of silver - but you can look up coins and find what percentage it is minted at. It does shine nicely, and is more scratch resistant than either Sterling or Fine Silver. Makes great front sights or thumb pieces. It is also usually more tarnish resistant than Sterling but that is due to the lower AG component.
So, you pays your money, and takes your choice. I do like coin silver for anyplace that it may get damaged easily - wrist escutcheon, front sight, etc. Fine Silver is great for barrel inlays, or for wire inlays.
Fine and Sterling Silver are generally sold by the Troy ounce, or by pennyweight (dwt or d) 20 pennyweight to the Troy ounce BTW.
Silver is, to me, harder to solder than gold. Harder to work with as well, as it needs to be annealed more often than gold. Let us know how you do, OK? Best of luck.