Sorry op you are dreaming
The reason that lovely, affordable, small, family care homes don't exist is because they are not economically viable.
Most older people want to stay in their own homes. Those who move into residential nearly all have some degree of dementia or heavy physical needs otherwise they would stay at home.
You need skilled, trained staff to care for these people but you will not be able to afford to pay them well because the council funding is on average £100 per month less than the cost of providing care. Therefore you will get less good staff who are not committed, there will be high turnover and constant worry about quality. Some will be really bad apples who steal the drugs or are abusive and you will need to get them out quickly but legally before they damage anyone so you will need to pay for HR support.
You will need purpose built premises with ensuite facilities as that's what CQC and families expect. You need to clean and maintain the premises to high standards. If you buy the premises with a commercial mortgage you will worry every month if you have enough money coming in fees after costs to pay it.
You will need to fulfil standards on infection control, food hygiene, medicines management, health and safety, employment law, deprivation of liberty and on and on.....
You will need a lot of financial expertise (or buy this in) to manage collection of fees, payroll, pensions, suppliers, producing accounts, paying tax.
The only way to make enough money to have a lovely, quality place with well paid, happy staff is to only accept private residents (council fees are too low) and charge a lot of money. However it is a competitive market and in order to attract private residents you will need a top notch place and a great reputation, marketing etc
Of course the social worker can fill a lovely care home with local authority funded residents paying rock bottom rates 10x over but either the home will not be very lovely or it will make a big financial loss.
These are the realities. You can figure out how I know.
It upsets me when people think that care home owners are raking in a huge profit as they really are not. Overheads are very high and fees are less than costs in many cases. Many small homes are going bust only big chains that can make economies of scale can survive.
People think fees are high but in actual fact it would cost you more to stay in a Travelodge for a year than a care home with no food or care included!