I have installed my fair share of pumps for cottage owners.
I always have used deep well pumps that I mounted on a welded up pedestal so that the pumps would stand proud of the silty lake bottoms.
Some advantages are: pump is always primed, never needs removing due to winter freeze up.
Most installations are into the 10-15 year spans without any problems.
In some installations I used heat tracing wire due to soil conditions and others are simply buried below frost line.
Those that are merely for summer usage I'd install a 'T' below water level and a ball valve on the 'T' so simplify seasonal draining.
Drainage was simple, shut off pump, open all faucets and then open the submerged ball valve.
Presto, system drained for the winter.
Reverse process for spring hook up.
No pump/system priming for me.
Should add, all told the $'s difference between submerged well pumps and piston or jet pumps is not all that impressive to not use a deep well pump.