General aviation pilot reported a persistent issue with N90 TRACON reluctance to clear aircraft on the GPS-A approach to LDJ airport.

Narrative

I was returning to LDJ on an IFR flight plan due to rapidly deteriorating weather. While LDJ was still reporting VFR; as was EWR and surrounding airports; there was weather in between my departure airport ZZZ and LDJ.I opted for the GPS-A approach into Linden; the only available instrument approach at the airport. The controller had to issue numerous delay vectors due to traffic conflicts to the Runway 04 approach at EWR. I was eventually cleared for the approach at DAPVY but warned that I would have to cut off the approach in approximately 7 miles.As I approached GEZSY on the GPS-A approach at 1400 feet; I still could not see the airport. Wanting to get down below a cloud deck in front of me; I asked for the visual approach. However; without the airport in sight; ATC could not clear me as I was below the MVA.A second controller came on the radio as I approached GEZSY (just 5 miles from the point where I was told I had approximately 7 miles before needing to terminate the approach) saying that I needed to either have the airport in sight or terminate the approach and hold.At this point I requested to cancel IFR as I could see that it would be VFR at my destination and there was ample cloud clearance for me to get down before arriving at LDJ. However; I do not feel it was appropriate for ATC to apply this level of pressure as I was flying single pilot IFR on a published approach.After I cancelled IFR; another pilot on frequency made a comment to ATC thanking them for being patient (presumably with me.) This was not an appropriate comment for a pilot to make on frequency.It is unsafe for ATC to pressure pilots to make decisions like this in IMC; especially single pilot. I am very familiar with the area and was comfortable continuing VFR. However; someone unfamiliar with the area could get into a lot of trouble very quickly.This has been a persistent issue with N90 and the GPS-A approach. N90 is always very hesitant to allow a pilot to fly the GPS-A approach. If they do not want us flying this approach; it should be removed. If there are non-standard procedures they want us to follow; they need to be published.A few years ago there was a fatal crash on the GPS-A approach at BAUTZ. The approach is very difficult to fly - and the fatal crash involved a pilot who is familiar with the area. ATC and the FAA need to take steps to improve the instrument approach to Linden; or remove it entirely.