I have spent quite a long time dealing with so-called "Tiny Houses" myself, as I didn’t want to pay rent from after university until the "real house purchase." Everything turned out differently than planned, since it didn’t actually go to Hamburg, but whatever.
There are many providers of small and modular houses. The latter were an option for me, as they can be moved and combined at any time. My idea back then was to buy one module and later place it on a solid structure. Depending on the provider, this works with more or less effort and costs. In any case, you can find many good floor plans on the websites; a tiny house only works if the planning is 100% correct. So it is considerably more demanding for an architect.
A proper "Tiny House community" does not really exist, but the Stover Strand campsite basically consists only of mobile homes, some modern and of good build quality, others still those old plastic ones from Holland. The owner is officially trying to obtain building rights for a Tiny House community on his campsite – whether that works is another question.
And to be honest, I don’t think RobsonMKK’s idea is completely stupid either, even if it might not have been meant seriously – it would just be too small for me, unless I were a student constantly changing residence. Beyond a certain size, a truck driver’s license is also required. A module could later also be used as a holiday home or rented out – of course, you would need land for that again.
Banks really are reluctant to finance very small houses or modules. The lending value is very difficult to determine, as the target group and thus the marketability are very hard to calculate or essentially non-existent. However, for a small amount, a "normal" loan might also be possible without generating exorbitantly high interest costs, or the lending value of the land minus demolition costs might be sufficient.
However:
The cost savings when building 50 sqm instead of 100 sqm are probably not as high as you wish. In addition, unlike in an apartment, the heating/technical equipment must also be accommodated; where are the clothes supposed to dry? Where do the motorcycle gear and so on go? Although I really like tiny houses, under 75 sqm would not be reasonable for me in terms of space and economically.
(as a student, with an appropriate campsite nearby (like it was at my place of study), I would buy a tiny house like the one below, nowadays there are several German providers of these originally American "houses," and then start a Europe tour with it. Afterwards, rent it out or something – by then, the house would have paid off anyway

)