A bit of a loaded question in some respects
My advice would be dependent on your own previous experiences whilst being in Thailand. Assuming that if you are looking to extend your stay or make it permanent, then you would firstly know the environment you will be entering.
I would say most relationship are mutually beneficial, whether short term or long term, emotionally, financially or both.
Only you can decided whether you feel comfortable in having that type of relationship, and, of course it depends on where you chose to settle in Thailand, ie in the centre of Pattaya for example or a more remote place with less temptations or opportunities.
Only you will find out what best suits you and how to go about it.
I know many Westerners who are expats in a relationship and they are by choice. One can only be a player for so long and that can be rather expensive and can yield diminishing rewards.
So my advice would be, take your time and as has been mentioned already, don't over think things. Only you can make your own choices.
Do what makes you happy and avoid that which makes you sad and draw from you previous experiences with relationships.
Of course, any advice you recieve, is likely to be based on one's own experiences rather than any given format.
Let is know how you get on with your quest and move to Thailand