Others can probably advise on aircraft rental than me, but the best two flying holidays I've ever had were in the Hebrides and west coast of Scotland.
The next best two were respectively in Arizona and California, which are outside the scope of the question.
G