a whole lot of value in.

On the road, you are on the money about "secure" hotel WiFi; if people you don't trust are using the same key which is typical there might as well be no WiFi key. Although HTTPS traffic is generally safe (it's using a different not-shared key to encrypt the traffic) , an extra layer which protects you from the easiest attacks in case there is some mistake in a website's design, the network configuration, etc breaking the previous statement might make it worth it. Additionally, even if your secure traffic is not flawed, it offers some additional privacy value on public/poor security wifi in hiding where you are browsing (even with HTTPS, the destination of the encrypted data is not encrypted) and any plain text communication (which is probably something you don't really care about, but at the same time would prefer other people not have access to).

At home (assuming you have a WPA2 network with a good key that you haven't shared with people you don't trust), you basically don't gain anything in security because all you've done is change where on the internet your data comes out the way you shoved it into the VPN. A VPN is like getting a police escort to the front of your neighborhood...for a cross country or international trip.

On the privacy front, a main benefit would be masking what your ISP knows about your surfing; if you care about that. To me, a bonafide resident of the United States with a US owned ISP that doesn't restrict traffic of a certain kind, that's a bit of a wash because now a VPN provider knows instead. Obviously that can go a different way depending on where you are and your opinions on various companies. You can possibly trick a web site/advertiser, but generally most aren't using an IP Address for tying data to you.

Changing your IP and therefore apparent location has some privacy value, but that's a little unreliable unless you completely trust your VPN to not give you up (so it depends who you are trying to hide from; google is probably not getting that information, but a government might) or to not keep any records of any kind. It does have a good bit of value in making video streaming sites with varying rights in varying countries make you think you are somewhere else.

Probably the number one case I'd use a VPN would be for when Will or Chris inevitably ban my IP address, I'd pick up a VPN at that point to sail past it.