I need some turntable guidance

Btw OP.
Please do not get the impression that anybody is trying to put you off.
Rather just make you fully aware of some of the downsides and what is involved to be SATISFIED with record playback.

I currently have a turntable but want to upgrade significantly.
I want a new one or at least a recent one.
I have a record collection.
I don't have a budget. I know where a supposed good deal is on a demo turntable for $10k. One of my questions is should I spend that kind of money or say are the differences marginal or great from a $5k to spending $10k? What do you get when you go up in price? Or what do you lose going down? Where is the sweet spot in higher end turntables? I think something matching to my system is where I should be but what price range would that be? 

I don't follow audio gear so I really am not aware of what my options are. There are no dealers in my town.

Maybe you could have opened with that information?
Lol.

A lot more there for members here to now go to town.

Wemfan, I need to know a little more about your situation. Is your equipment stand (cabinet) on a wood platform floor or on a concrete slab? This will determine if you can use any turntable (concrete slab) or just suspended turntables (wood floor)

It would be helpful to know what you have but regardless, my recommendation would be to get an AMG Giro with Turbo tonearm. It will not disappoint.

You should be able to get a demo under $10,000 including tax.

Another option is the AMG 12, Airforce 5 or a Basis turntable. Those might not fit in your non-budget