submersible runs cooler, and there is never a requirement for a foot valve for priming. If you can afford it, submersible is the way forward.
I dont think running pressure from a submersible or mass water transfer pump of any type is an economical way to go, as you then need to just increase power to overcome the need for pressure. which is stupid.
Personally, i use a 100 watt solar panel charging a lead acid battery powering a 12v 36 watt constant pressure pump, which i literally just pull the water out of the well with. (about 10 m deep, and i get flow of about 8 LPM)
A constant pressure pump from your tank to the house would be the best solution if you need multiple faucets and toilet cistern etc, and for this you could get away with any power constant pressure pump.
You then just need to be able to get the water to the tank, not under pressure, just get it there.

Read this document:
https://www.ihs.gov/EHSCT/documents/...cises%20r1.pdf


Lift: Submersible pumps do not build pressure. They provide lift which overcomes head pressure.

Personally, i think a half a horsepower, or somewhere below 400 kw would get the water to the surface fast enough where it can be pressure pumped to the house with a separate pressure pump.